He stood up in front of the UN and put up all the evidence that was the basis for the invasion. None of it was confirmed after the invasion - so he and Tenet resigned.
I don't recall him saying that was the reason for his resignation, but you could be correct.