AI still has a long way to go to create emotion and deal with complex problems like occlusion, so of folks who work on big shows/films they aren't too fussed right now and some will be using forms of AI within their toolset/pipeline to help them, which is a good use of the tool.
For those further down the pecking order that begins to change - people that create single images (artists) and things like animated corporate videos then yes, they are already seeing work going to the the new AI overlords.
The biggest worry will be how studios view AI (And yes, there was just a big strike all about this) - but at some point execs will point to AI to reduce their out of control production budgets and that could be a tipping point.
On the other hand as UI on the tools gets better and the ability to create consistent and repeatable characters develops it does open up creative options for people like writers who what to bring their worlds to life but can't afford to use studios, (in fact it could allow Indie studios to take on the big boys) - so you will see a rise in singe creator content at some point, much of which may never have been possible before.
Interestingly Tyler Perry just pulled the plug on an $800m animation studio directly citing the rise in AI making what he was going to build redundant....