You're right. He should do what Petraeus did when he was blackmailed. Not resign though.
He has a very good reason for not resigning, and he can state that as well -
0bama will appoint an uber-leftist radical in his place.