I've played around a bit with Stable Diffusion and as far as I can tell, it's just a new tool, like a much better paintbrush.

It still needs a human to tell it what to paint, and the best outputs generally require hours of refinement and then possibly touch-up in photoshop. It's not generating art on its own.

Artists still have a job in deciding what to make and using their taste to make it look good, that hasn't changed. Maybe the fine-motor skills and hand-eye coordination are not as necessary as they were, but that's it.