Have you ever seen people dreaming of becoming a soulless cog in the machine creating forgettable 3D assets for mobile video games at a no-name studio once we achieve "full automation"?
Me neither.
What people dream about is being able to go to a field and paint or sing at their leisure, not engaging in the soul crushing rat race that is artistic entrepreneurship.
AI is replacing the jobs that make money but are most certainly creatively bankrupt.