No Democrat ever resigns.
And he will win reelection easily. In 2010 Weiner won with 61% of the vote; in 2008, with 93%; in 2006, unopposed; 2004, 71%; 2002 66%; etc. Weiner is in Schumer’s old seat. No way a Rep wins this seat.