What exactly was the damage he did?

He exposed massive unconstitutional dragnets that made the unaccountable agencies look bad.

If the damage is "makes the US look bad from their illegal surveillance of citizens", then the NSA did that to themselves.