I think as a society we shouldn't be looking at automation as "Oh my god that machine is going to eat those people's jobs" - we should be looking at it as "Wow, we collectively don't have to do that crap anymore" Similarly to how somebody looks at a Roomba and says goodbye to pushing a vacuum around for an hour. But what fucks this all up - the distribution of money. Because the way distribution of money works in America, we look at it as those cashiers are now going to starve and die.
MBA thinking has morphed us into thinking life is about production and consumption (full stop). Its not (full stop). The majority of the population is relatively starved of the 'other things' in life and we should be reevaluating how automation can help us all focus on the things that make real life a better experience. Unfortunately were too busy all miserably hoarding money from each other like a bunch of dumb apes.
So back to your question about excess creative production - we shouldn't care about who consumes it in an idealistic scenario. If people genuinely enjoy the creative process, they should be doing it because they enjoy it and hopefully that can be more afforded by automation.