Climategate didn't show that AGW is not real.
What it did do is ruin the credibility of many of the more important 'scientists' involved with the data behind it and show that science can be easily manipulated, much like anything else that exists.
That doesn't ruin AGW so much as render it much more suspect.
Which is reflected in the public opinion of no longer taking it that seriously.