I have a feeling that yesterday when he was meeting with the Senators they gave it to him straight that he wasn't going to make it through confirmation without his past being made public.
People have said that he might end up returning to his seat for next Congress because he only resigned from his current seat however that would defeat the whole purpose of what he did with resigning. The Ethics report would immediately come back up and given its really done it would hit him immediately. It will be interesting to see what his next move is. I would expect he will go away out of the public eye for a while and reemerge in a year or so