Of course the NSA will weather it, will continue to exist and will continue to spy. For them it's a (short) embarrassing time after which the news media will forget them and all will be the same for them again.
The ones who pay for this are the US IT companies which will be distrusted world wide and the US government (politicians, diplomats, secretary of state, etc) who will be distrusted even by their closest allies. US companies will notice it in the long term bottom line e.g. when big foreign companies won't outsource to a US company. The public will forget the scandal soon like they forgot Echelon, the big companies who have actual trade secrets however won't, and if they do they will probably regret it soon when their secrets aren't secret anymore and their US competitors magically know everything they do. These losses are however far in the future: more than a quarter away so they will be denied, at least publically and especially by the ones responsible: the politicians.
The politicians will have a lot less trust and goodwill from their foreign counterparts, even and especially from allied countries.