Well he's lost his show already, but I reckon he'll get something else big out of it. There was speculation about a HBO show that would net him $4mill an episode, but I think that's been quashed now.
And fair play to him if he's been caught out as a massive drug using, misogynist and the only penance he has is an enlarged pay-check. Sure he might lose a couple of dozen million in the divorce, but he'll get that back.
Some
PUA's idolise Mystery (and other "master
PUA's" because he lead somewhat of a playboy lifestyle, with their mansions, multiple partners, drugs and alcohol and all that jazz. The only difference here is that Charlie Sheen is a celebrity, ipso facto was born into an easy pick-up due to his background, rather than having to work on the skill.
Turning any negative into a personal advantage is a good thing in my eyes. Take Zack Anner for example...