It's hard to forecast what will happen to artistic endeavour in general. Whenever previous technological shifts like this have happened, new artistic roles emerged to utilise the new powers.

But what is certain is that it is going to be extremely disruptive to those who've spent years honing their craft, and are relying on that craft for their livelihood, but aren't superstars. Demand for their artistic skillset is going to go through the floor, and instead it's their meta-knowledge that will make them valuable. But that's a very hard shift to make for many people.