I don't hold out a lot of hope for actual AI. AI has been promised 'real soon' as long as I've been doing computer stuff, haven't seen it yet.
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.