A Rock N Roll Mercenary is someone who is in the music business just to make money.
it's not for the song
It's not for the love
It's just for the gold
and it's never enough.
It's someone who has no passion for the work, it's just a means to an end to make themselves rich.
I don't think the song is about any one person in particular.