Who lost their jobs to the printing press? The monks who were the only scribes back then? They got their time freed to spend it on other duties in the monasteries and mayhaps even more time to read other books rather that to scribe them. So the level of education grew even for them.
The same will be for the FX artist and 3D artists etc. The level of their work will grow, they will spend less time on dull work and more on tinkering with tiny but more important things like ideas, emotions, art overall etc.
Depends on what you think is "dull work". I think there are many artist who could welcome some of the "creating work" to be automated. What part? Depends on the artists and his preferences. AI can take the burden of any type of work and leave those parts which are needed for the human to do. Human can choose what parts he will work on. That's the point.
Why the terror? Your job will change a bit but won't be gone. You would guide the output and make prompts not with text but your own video CGI shorts to make things 100% to your liking and the AI will do the rest of the dirty work. You productivity will grow and quality of your work too. You would be able to make an AAA movie all by yourself on a laptop. Since everyone would be able to do the same, the fight for the imagination and inginuity in scripting and artists view would skyroket. :) IMHO
The same will be for the FX artist and 3D artists etc. The level of their work will grow, they will spend less time on dull work and more on tinkering with tiny but more important things like ideas, emotions, art overall etc.