Someone will inevitably have to prompt AIs, CEOs and other executives are NOT going to be doing it themselves. The people driving those AI will have greater leverage as less and less people choose a career in tech.

Also, when an AI fucks up in a way only a human can fix, the human must be available.

What I see more likely is a future where software engineers do even less work but frustratingly you still need them around to fix problems whenever they come up. Kind of like firefighters.