Hm, anyone who's a nerd, artist or performer will tell you that's only partly true. There's intrinsic motivation, sure, but artists and performers also have an idealized audience in mind; someone to share with. It could be a spouse or family, it can be friends, but there's almost always someone. There is for me, for my performer friends and family, there's for musicians I know.

Motivation is a fickle mistress. It can definitely be killed if you feel what you're doing is pointless.

Even more, motivation often arises from struggle. If you remove all struggle, if everything worth doing is done by AI/machines, and everything exciting is happening someplace else inaccessible to you, that will be catastrophic.

I'm also reminded of Philip Dick's "Autofac".