Before the invention of alarm clocks, we had people who used to go door-to-door to wake up people. They were called knocker-uppers.
We don’t have that kind of job anymore.
But we do have a lot of new jobs that were unimaginable a few decades ago. Who thought podcaster or YouTuber would be a full time job.
Certain parts of programmer's jobs will be automated away. But that’s the case with better IDEs, open source libraries, boiler plate templates. You still need a programmer to put things together.
And jobs will always need new skills. Not sure whether prompt engineer would be a job in the future, but everyone will need prompt engineering skills.
DALL-E 3 aims to remove the need for prompt engineers for creating images.
So there will always be innovation happening and the only thing that is constant is change.