People across the political spectrum got upset at the government. I remember being swept up at the time in the general nerd rage against the NSA. I particularly remember watching left-wing media about it from creators that were, around that time, partly sponsored by Russia's propaganda arm RT, though whether RT specifically sponsored pro-Snowden content from those creators I don't know.
However the actual political results were mostly favorable to Republicans. Trump himself popularized the term "deep state" and criticizing it was a key part of his administration's PR.
Russia benefited, not only by getting Republicans in power, but also by embarrassing and casting doubt on U.S. intelligence, a year before Russia's invasion of Crimea. Now in the current Ukraine war it's obvious how vital NATO intelligence is to resisting Russian aggression.
I don't think much actually changed at the NSA or any other agency. Trump didn't actually care about the ethics, he just thought it was some huge, personal injustice that he couldn't command everyone in the executive branch the way he could in his businesses. He didn't even pardon Snowden.
So overall the only changes were political and it all worked out great for Russia. Maybe Russia didn't plan it but they sure benefited from it, with the public and the media doing the heavy lifting. Something to keep in mind the next time some theoretically nonpartisan government scandal appears.