I guess it is not easy for people working in the industry and there is no escaping from the fact that this will replace some of them
As for the specifics, this is obviously the case, if you want your own details, you will need to do them.
Not sure have you seen, the new ragnarok game coming on Hive by theycallmedan will use AI art, with a retouch from artist... like 70% ai, 30% human ... this might be how this thing works going forward
This will definitely be the case moving forward. You can't kill things that make that much financial sense. Back in the day I worked in a game company and for all the art that we could we'd hire companies in either China or India to do the bulk of the work and us artists in the US would just "fix" their art. We'd only do the stuff that was too hard of them internally. Unfortunately it will primarily be those sorts of people who get screwed, not people working in big film/game studios. They'll be fine.