Oil will be king for along long time. Oil is not only fuel, but raw material for many other products from fertilizer to plastics etc. It is what “renewables” are made from both ion terms of power to manufacture as well as base materials.
Oil has more power to mass than most anything other than nuclear, is cheaper to harvest, we don’t eat it nor do we have to do much more than cook it to make fuels and other byproducts (wax to asphalt etc). Unlike etoh, h2 etc, it gives us more power than it costs/consumes to produce.
Oil will be the fuel of the 24th century and beyond!
The majority of that feedstock for petrochemical is natural gas liquids, ethane to pentane+. Refineries do produce it, but we are getting more from Natural Gas processing.