There is one big reason that Weiner has a chance of continuing a career in politics after dropping the ball bigtime, that he never campaigned on being a moral person. I could probably rattle off a dozen politicians who were elected or maintained elections by trumpeting their "family values" whilst hiring prostitutes or screwing their staffers. When you campaign on the sanctity of your personal life, and then get caught with your pants down, your personal life becomes the public's business. If you've never pretended that your pants managing skills are a reason to vote for you, then it's embarrassing sure, but it's not a reflection on your quality as a public servant.
Weiner's mid-week Full Ginsburg to run his hacking lie is another matter, and how he could have possibly thought the politics-requisite non-denial-denial would work for something like this is pretty baffling. When there's a photo of somebody's junk floating around on twitter, and you're asked if its yours, "Yes" and "No" are the only acceptable answers. Nobody believes you if you say you can't be certain whether it's your own junk in the photo.
He's going to be clobbered with this to be sure in his own next election, and that's as fair as anything. My advice to him would be to own it - he represents a slice of New York City and has the ear of Jon Stewart. The best strategy for taking on personal embarrassments that mean nothing to your office is to make your human side your good side, attack yourself before anyone has a chance to attack you. Own the panic, own the confusion, own the humility, and own the meat torpedo and rock hard pecs.
My advice to anyone who thinks Weiner should be used a cudgel against any other politician or party is they are making a dire mistake. Let he without sin cast the first stone and all, so anyone who wants Weiner's junkshot tomfoolery to be a national issue should put on a helmet and get ready to catch some rocks.