This is extremely uncommon.
For example, I used to be a submarine officer in the Navy, and I left as a conscientious objector because of this realization. In an average year, less than 100 active duty service members will apply for conscientious objector status (there are over 1 million active duty personnel). If you take a look at [this graph](http://izbicki.me/blog/most-conscientious-objectors-are-not-...) based on GAO data, you'll see that the number of conscientious objector applications dropped significantly after September 11th. This is despite the fact that the wars afterward have been much more controversial and less just.
Why is [NSA moral] low?
I'd bet it's not because of any ethical conflicts. Instead, it's because 100s of man-years of work is going out the window. One of their own betrayed them. This would be demoralizing even for the most ethically unquestionable teams.
The pressure is increased while blame flows down The Hill through every office and cubicle. New procedures are set in place so that supervisors can tell their supervisors what steps they've taken to ensure there won't be another Snowden. Peons scramble to adopt these new procedures all while under closer scrutiny from everyone around them. Everyone, including the janitors, are pressed to find "traitors" in their ranks. All of this while harvesting/analyzing new data and shredding/deleting evidence. I'm guessing that $100,000+ salary is fast losing it's allure.
Rightly so, because this work should never have been done at all!
And the only way a government could pull that off would be to do something drastic, like if it forced all citizens to sit listening to government employees deliver government curricula for 8 hours a day for twelve years during some of the most formative periods of their lives.
Most countries I lived in don't prompt either. (And in Germany, people would be out on the streets if a school did that kind of prompting.)
http://webarchive.nationalarchives.gov.uk/20130401151655/htt...
"Since the 1944 Education Act, re-enacted in all subsequent Education Acts, there has been a statutory requirement that all maintained schools must provide a daily act of collective worship for all registered pupils, unless they have been withdrawn by their parents. The Education Act 1988 removed the requirement for this to take place at the start of the school day. Collective Worship can now take place any time of the school day."
In practice, the law is widely ignored.
NB: I went to CoE schools for 7 years of my K12 education, and came out an atheist. I think part of it is to do with the teaching - even at a church school, we were encouraged to question everything, and had at least an hour a week where we learned about other religions in a very objective light.
I believe that on many levels, education comes down to that learning to question - and when you're told to believe things unquestioningly, you're intentionally breeding ignorance. My take is that it's not so much about schools having prayer etc, but the way they encourage thought. Kids are smart; if they're allowed to think for themselves, they will.
The issue is quite subtle and there are a few factors at play. One is the basic need to believe their "team" is a good team. This works with the brainwashing. "Teams", "us vs them" is ingrained in our tribal brains. We want to think our team is the winning team. We are better, special, not like "those others".
It is really working against the flow when attempting to show our citizens that "yes, our country has done these horrible things to others". They is an irrational immune response against it, they have been believing their family/their team they've rooted for now has a dark secret, its past marred in shameful things. They have been telling others, their kids, and themselves how great our country is, and now look! -- a total reversal, "what, have I been living in a fantasy world all this time?" kind of bewilderment. So instead of exposing and handling the hard truth, it is easy to bury it, stick fingers in the ears and say "la-la-la, I am not hearing you, ..."
This also is interesting because it kind of explains what happens in the brains of many who work for CIA, NSA and other such agencies. They are supposedly hired for their exceptional patriotism. Now sometimes it backfires, because they realize what they have to do in their jobs contradicts the high idealized patriotic beliefs of what this country is about. So there is Snowden, he is one of them. What about others?
There was an article just yesterday about how "Morale at NSA is low after the leaks". Hmm, it is low. Why is it low?. Good to explore. Did many realize they have been playing for the bad guys all this time? Or do they just feel angry about one of their team members "betraying" the team and they don't see anything wrong at all with what they do. To keep their nice govt job are they forced to believe one thing in their heads ("this fucking contradicts what our Constitution is all about!"), and profess another thing at work publicly. Much like North Koreans perhaps. Cry with happiness when "Dear Leader" drives, but curse his guts in their head? Who knows.
Another way to look at it is from a psychopathic, practical aspect. Do people just acknowledge the situation for what it is and say "yes we are bad and we love it". "We conducted these attacks? Great! Let us do more. If it means a blowing up a few civilians so be it." I can image many at the top operate on this principle.