I think there will always be a place for real music artists, but I also think people will start listening to more AI music as it starts getting better.
I think you're right though that we'll see artists who can't sing just lip-syncing along to the AI. If I go to a live show, I want the singer singing live, not lip-syncing with an AI.