I think it will decrease iteration time during an exploration phase for new artists or when you're not quite sure what you want and want to explore your idea space more quickly (and maybe even get new ideas as you iterate).
It's similar with these coding AIs. A lot of the time it's great for the "blank page" phase of a project where you have to do all the "boring" stuff out of the way. Another great example (I think it was a blog post here) where the AI recommended a method the author didn't know about that yielded a crazy performance boost.
I tried to get some help from copilot on writing a shader the other day, and it was really an amazing experience. One still needs to have a pretty deep understanding of what needs to be done to use these tools.
I imagine it's similar for writers. Maybe they want some help to reword a sentence to be more succinct, but the ideas will still come from their heads.
I can't predict if this will one day be so sophisticated that you can have it do both low level and high level "thinking" when exploring ideas, but if that day comes I don't think it will mean an end to jobs, just that some jobs will become more accessible, or that it won't be so much about nitty-gritty work and more about higher level idea-level work (which to me sound good, not bad).
Obviously there's people who enjoy the nitty gritty (as a developer, and amateur painter who does enjoythe process), and I don't think that will fully go away, just become more of a creative/artisan field maybe. Who knows, though? I may be way off, but I don't think it's as bleak as some people fear.