I'd have to say that poster's comment doesn't really fly with me.
For one thing, making a name for yourself in history does not mean you lived like you were supposed to live. There are bad names in history too, and we don't like them or praise them for living just because we remember who they are. We remember who they are so we can avoid being like them.
EVERYONE wants to live their life, finding some sort of happiness. There's nothing special about a person trying to get what they want and find this bliss, let alone a star who happens to do all the wrong things in such an attempt. Remember that special treatment we were talking about? The treatment we give to actors just because people idolize them and whatnot? We're still doing that, by making such a big fuss over all this. We're also still doing that by coming up with excuses for such behavior.
The problem with Charlie Sheen (and, a lot of people actually) is that in his search for happiness, he doesn't change what he does, and always gets the same results. He marries, then cheats and does drugs, then is divorced. The smart thing to do is try something new, maybe try and change your perspective in life, find other things to do. But no, Charlie Sheen decides to marry someone else, then do other drugs, then cheat with someone else, then get divorced again. History repeating itself.
I guess one big problem, ironically, is what the media perceives as gates to happiness. How many movies have we seen where the druggie is a hero, or hot babes are what all guys should go after, or that divorce or being a baby-momma isn't that big of a deal? Tons. Why? Because none of that is true, but with all the real problems people are facing out there, an hour or two of film where that stuff isn't so bad, is definitely going to sell. It acts as a sort of relief to reality.
And with all the TV shows we watch and our dependence on technology these days, lots of people make the mistake in believing all that, and end up mimicking and chasing over a fantasy life that has been seen so many times in movies or TV. A fantasy life that DOESN'T exist. Hence the term, fantasy.
Sure, there's some short term bits of happiness, but in the end, it can't ever go well.
What it means to live is to face your problems, find solutions, help others with their problems, and aim for being content with your life in the end. Looking out for others is important too, because if you don't, then you're being a nuisance, you're hindering others, and then chances of finding happiness in the end will close. Because if you're all alone, how can you be happy?