I hope that oil can become less important like coal and asbestos. Then these countries dependent on oil revenue can just eat sand and rock literally
That's not going to happen.
Something that many, poorly informed people, assume is that we can reduce our consumption of oil by reducing the number of miles driven in our automobiles. That's not the case. Crude oil is a feedstock for refineries. Refineries produce their output through a process of distillation. As a result of distillation, a barrel of crude oil produces the feedstock for plastics, for chemical dyes, fertilisers, road construction, aircraft fuel, diesel, heating oil, bunker fuel, gasoline and many others. As long as we need any one of these products ALL the others are still produced, even if we do not use them. Refiners can choose to specialise in certain weights of input crude (one of the reasons the US imports large quantities of oil - US refiners can not work with the oil grades currently being produced from the unconventional sources so much ballyhooed over there.)
So, as long as we use plastics, as long as we use chemical dyes, as long as we use ships that use oil, as long as we need lubricants, we will be producing diesel and gasoline. Because we currently use all the fractions of oil that are refined the overall use of crude oil will not decrease to any significant degree. The best that can be hoped for is that oil use might not increase much, as we move toward natural gas as a feedstock for power generation.