Really, unless the heat becomes unbearable, I think his constituents (perhaps more importantly, his big campaign donors) will decide his fate at the ballot box. I mean we have a current Massachusets Congressman who frequented call-boys, a current Louisiana Senator who apparently likes the wear diapers when he frequents prostitutes, and until recently a Neveda Senator who slept with the wife of a member of his campaign staff and then paid off members of their family to try and cover it up, and an ex-president who liked to have his cocked sucked by an intern at the whitehouse but finished out his term afterwards.
However, what's even more dispicable about Weinergate is the Congressman's cover-up attempt to blame it a on hacker with a right-wing agenda, than what he actually did with his weiner.