Charlie had the greatest likelihood of recovering and living a meaningful life. He's a playwright (though it isn't clear if he's had any successes apart from his collaboration with Frank), and as Radcliffe rightly noted, he's well-grounded in his personal life (he also seems to have basic common sense).
But Mary has basically no hope. She's a drunk, her life is empty, and although it's just possible she's finally woken up from the fantasy world of hanging on to Frank somehow, I don't think the show gives any indication she has that sort of inner strength.
Frank actually isn't a failure, he just isn't likable. The first incarnation of the musical suggests he was now washed up, since his big movie is apparently a big bomb, but later productions have made him a still successful producer. Nor does he have any addiction issues preying on him. He probably won't ever be able to really commit to anyone, and he likely will always put the dollar first. But if that's some big tragedy, I'm missing it.
Really, the show just doesn't make sense--didn't make sense in its older, hectoring, moralistic version, doesn't make sense in its more even-handed revisions. Of the characters, only Charlie is given believable motivations for why he acts as he acts. And none of them are well-developed.
But it's got a gorgeous, tuneful score, and the show works emotionally.