The NSA is under pressure from the public, less so from the intelligence and defense communities. If anything Snowden has caused those areas of government to close ranks even tighter. There's nothing a leader wants more than a highly visible enemy to unite his or her people. There are orders of magnitude more people who hate General Alexander now than there were two years ago. But his own people love him even harder.
The NSA may or may not lose some funding in the coming years. It will probably just transfer over to the NRO or the Office of Intelligence and Analysis or one of the dozen other agencies that we haven't come to know and hate yet. If there's one thing government is good at, it's maintaining the status quo. Public support has never meant much to the intelligence community. These are people who signed up to serve in secret, who have dedicated their lives to what they believe to be just causes. They won't pay a thought to a year or so of bad press.
Snowden's future is unclear. He'll probably be in russia for several more years, if he doesn't overstay his welcome. It's possible that some future president will see pardoning him as a free goodwill card. Or perhaps he'll be able to start a life as an overseas media personality, reaping the benefits of what many see as a heroic action. One thing is for certain: US intelligence agencies will continue business as usual.
Edward Snowden has shown the light, and his work is indeed done. It's up to us to effect real change and shape our government in our own image. Maybe things will change, maybe they won't. But those who dislike what he has revealed have their work cut out for them.