Same with programming.
In tech, new tools open up new use cases. People thought calculators and computers would be the end of mathematicians and scientists. In fact they opened up those fields to even more people, and allowed them to solve even harder and more interesting problems, while the technology does the drudge work. You don’t have to be a savant to be a good mathematician anymore.
AI doesn’t have emotions (yet), so it doesn’t want anything. Wanting is a crucial component of innovation. Without wanting, there are no problems to solve. Once AI does have emotions, I don’t imagine their desires will resemble our own. Humans will always have problems to solve, and people willing to do the work of solving them.
I’d worry about running out of resources before running out of problems for humans to solve. If you are willing to adapt your skills and use the available tools, there will be work to do.