There are many pros and many cons. It just depends on which side of the fence you are on.

If you work in an area where AI is inevitably coming for your career, like me, then there are obviously a lot of cons, lol. There are also pros, like using AI as a tool to assist you, as you had suggested. But imo, the window of opportunity to use AI as a tool to assist you is going to be incredibly short lived at the rate things are advancing. It will be a helpful tool.. Right up until the tech is good enough and easy enough to use that anyone can do it. Which, with how quickly things are going, how far off do you really think that will be? 3 months? 6 months? a year? Its going to chip away at the creative job pool more and more until entire companies will have one, maybe two people working in their creative offices. I personally think eventually that number will be reduced to 0. And when it comes to creating live action work, a single production can provide anywhere from 10-15 jobs, up to hundreds (depending on what you are working on.) That's a large amount of job opportunities gone, just on one production.

Right along side that though, one of the main and most fascinating pros imo is exactly that, Anyone will be able to generate any idea they have. There are probably incredible untold stories that we could have seen or known if people just had the artistic skillset to get them out. But learning how to art is hard, and not only that but there are so many avenues you have to learn to produce a visual piece, its daunting and seemingly impossible to do alone.

The real question then will be how accurately can AI generate the story that someone has in their head? how difficult will it be to cull the AI's generation more inline with what you are thinking?