It won't just make the USA irrelevant in the oil domain: it'll impact the entirety of the OPEC group who'll have to massively scale back production to keep the price high enough to sustain their economies.

The petro-dollar will be replaced with the electro-dollar (that is if the US dollar remains the world currency). So a different group of rare earth rich countries will emerge that'll become more relevant than OPEC in the energy domain but not quite to the same extent as countries that are both gifted with geography to make them major energy exporters and have neighbouring countries/super-grid connections/renewable storage export capabilities will emerge as big players as well.