Yeah, that is probably never going to happen or if it does it's so far out that it's not worth speculating on.
The past 100 years are a great example of how a lot of change can happen in a short amount of time.
There are some things that you can automate -- but a lot of things in the oil & gas industry cannot be automated. Specifically, the leg work required to get things started & keep them maintained. Automating those sorts of things requires a pretty advanced AI and I don't see that coming around the corner anytime soon.