Then you think a rich porn star is the pinnacle of a successful life?
Why on earth would you think that?
Oddly enough, the "little faggot" on MTV most likely isn't even gay in the MFN scenario... the earring and the makeup are part of a show business persona adopted for the music videos. Your average construction crew doesn't necessarily get this, and from my exposure to such crews I can tell you that the term they would adopt for such a character is nailed dead-on in the Dire Straits song.
Don't construe my answer to mean any more than that, or any endorsement of any lifestyle. In interpreting the song it's important to remember that Knopfler is in fact a rock star, and he wrote the song to remind his self-pitying rock start brethren that as a group they really do have it easy.
After all, they could be installing microwave ovens for a living.