said,
"His long term goal is to eliminate oil and gas" Musk is a leftist that believes in peak oil. The concept that we have a limited supply of oil. When in reality Oil is one of the fastest naturally produced substance on the planet.
Though at the rate we're using it we will eventually hit the natural reproduction rate. I would estimate about 5 to 10 thousand years. It's not urgent thought it's something long term we should consider.
I would suggest Musk as a lower figure of hundreds years.
Here is the process that creates methane which all crude oils are from. Video is for humans to produce. Though its generally the same method. Syngas is simply methane mixed with CO2
https://www.youtube.com/watch?v=kI7s6IRpOHA How methane is produced in nature.
paper mantle metasomatism shows methane(CH4) as a product. Carbon dioxide in igneous petrogenesis: II. Fluid dynamics of mantle metasomatism
https://www.academia.edu/11512615/Carbon_dioxide_in_igneous_petrogenesis_II_Fluid_dynamics_of_mantle_metasomatism
This is a location oil could be produced using the earths core.
Deepest-ever samples of rock from Earth’s mantle unveiled (Atlantis Massif 30°07'48.0"N 42°07'48.0"W) Looks like a 10 mile long phallus chose to drill at "Lost City," a site on the southern side of the massif
https://www.nature.com/articles/d41586-024-02560-w 