Let's say there is a usd asset exported from somewhere with usdpreview surface materials, how to load them as independent material subnetworks in material library then I can apply my script to convert them into karma or redshift materials etc

There is no automatic building of material networks afaik (maybe RFE), so you'll have to bring in your materials and then use an Edit Material Network LOP to extract the network from it.