I agree with you, but not in the longer term. Robots + AI = 80 person Standard Oil.
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.
Automation can get us close. Already has, but this just moves the labor out of the field and into a cube.
But (I think others have pointed out downthread by now) capital intensive projects are always going to need someone to go out and kick the tires, work a nut loose, apply some ingenuity.
If you don't have those guys hanging around to kick the tires and whack a lug nut things will stop until you send a guy out to do that.
The probes we have on Mars .. you can wait a few months for the guys at mission control to work out a problem. You can't do that with an oil well.