It might happen but it's extremely difficult even using state of the art models like stable diffusion v6 to get consistent results. There's usually some part or the other of the picture that's broken and it takes a lot of work with prompting, blending, varying to get it to work.
Buy the subscription for 30$ or whatever and give it a shot. First you'll be amazed but then you start noticing the minor flaws and how much effort it takes to make it good enough.
It's still possible that some jobs will get replaced, not every NPC detail needs to be hand drawn perfectly, but let's see.