The song that I think would compile with the fewest changes to the language spec is Scorpions' "Rock You Like A Hurricane". I don't think it'd reveal any hidden meaning or anything, though... it's really just a long list of assignment statements. You need to spell 'Night' on line 2 with a capital 'N'; same with 'What' on line 4, and some liberal use of parentheses, but the first four lines do actually compile:
It's early morning, the sun comes out
Last Night was shaking and pretty loud
My cat is purring, it scratches my skin
So What is wrong (with another sin)?
The rest is, um, work in progress. And it may not be a coincidence that the stack push/pop operators in Rockstar are called "rock" and "roll", and the syntax was designed so that "rock you like a hurricane" is syntactically valid Rockstar code.
Compare "Black Perl": https://en.wikipedia.org/wiki/Black_Perl (It was posted anonymously, but I remember reading somewhere Larry Wall has later admitted to being the author. Wikipedia claims authorship is still unclear, though.)
Although it could be fun to do "reverse Perl poetry", and find Hard Rock / Hair Metal songs whose lyrics are valid Rockstar code. That way, we could finally find out what that one special song really means.