I like the idea of we will always need Pilots. We have autopilot and i'm sure if we tried could automate take off and landing of commercial flights. But we will keep pilots on planes long after they are needed.
But you still need the pilots because the system can only handle the happy path. As soon as there's any blockade or strong weather change, the autopilot will just turn off. And then you need the pilots.
I would say software engineering with AI is similar: The AI can handle CRUD just fine. But once things get messy, you need someone who can actually think.