I tend to agree with you that Tenet was more of an ignorant stooge than a master planner. He was only head of the CIA for a decade or so, whereas the real troublemakers were the long-term professionals. But Tenet was enough of a clintonoid to tolerate the existence of a large number of traitors in the CIA, whose activities were far too blatant to have remained unknown to him.
For instance, I think he probably was not in on the planning that sent Wilson to Niger. But when the whole thing came out, why did he sit there and do nothing about it? Why was there no internal investigation to find out who authorized it and who told Wilson that he didn't need to sign a confidentiality agreement? Why did he sign off on the CIA giving a false briefing to Fitzgerald? I agree that he probably wasn't at the heart of the conspiracy, but he did a lot at various times to help it along. That makes him thoroughly guilty in my opinion.
See, I'm wondering if there wasn't a Wilson (and possibly Clarke who wasn't in the CIA?) faction/opposition to Bush and/or Tenet that was from the outset trying to undercut the War on Terror.