I think we'll never stop extracting oil in the foreseeable future, we'll just be doing a lot less of it. There will always be corner cases where diesel or other oil derivatives (or NG) are the /only/ reasonable option for fuel.
Think generators for an antarctic station that can only use solar in certain months and wind isn't enough (or reliable enough)). Even if efficient electric commercial aviation at scale ever happens, you can bet military jets will still need jet fuel. I'm sure there's many others. Methane for rocket launches?
On top of fuel, there's also the use of some fraction of oil in industrial chemical processes to make lubricants and plastics. There may be other chemical processes that can do it without oil, but they may be too costly (in terms of other extractive processes for ingredients, or in terms of yield, not just energy).
Think generators for an antarctic station that can only use solar in certain months and wind isn't enough (or reliable enough)). Even if efficient electric commercial aviation at scale ever happens, you can bet military jets will still need jet fuel. I'm sure there's many others. Methane for rocket launches?
On top of fuel, there's also the use of some fraction of oil in industrial chemical processes to make lubricants and plastics. There may be other chemical processes that can do it without oil, but they may be too costly (in terms of other extractive processes for ingredients, or in terms of yield, not just energy).