It's possible that the Plame and Chalabi investigations will make the CIA look so bad that people will demand that the director resign; anticipating that, Tenet is launching a "pre-emptive resignation."
I forgot to mention the 9-11 investigation as another potential source of calls for Tenet's resignation - Chalabi, Plame, 9-11; three strikes and you're out.