A piece generated by Midjourney beat human artists in a competition judged by human artists. So there's good evidence to think these jobs are going to be replaced to a decent extent.

Human artists will still exist, it's just going to be democratized. Sort of like the impact of social media on traditional news journalists.