AI definitely can't do everything, so there will always be some things that require the human touch. I expect AI will generate code in the future (I think it already does) but humans... as you suggest... will need to tweak it to actually DO what the person requesting had in mind.

I expect I will always write and create art.