I think it does make the administration look bad. I don't think anyone lied, but Bush, Cheney, Powell and Rumsfeld swore up and down that Iraq had WMD, so the intelligence was obviously wrong.
The fact is that Saddam was not cooperating with the UN, and that alone was enough in my mind to go in there. After years of his BS, we finally said 'Enough!'
We said we knew where they were, not just that they had them.