tbf fantasy illustration in particular has basically never been a good job, unfortunately

even before this AI kerfluffle wotc was paying bargain-basement prices for genuinely incredible work, and they were considered one of the better employers for that stuff

the holy grail for a fantasy illustrator is being a long-term house designer for a major studio (of any kind), but those jobs are unicorns compared to the number of skilled illustrators looking for work