If the idea is that he is working for the CIA against the NSA, then it is still too mind-boggling when you consider the consequence of Snowden's revelations and the damage it has done and will do to the US spying program and the country as a whole. Smells like 9/11 conspiracy all over again. If the CIA wants to work against NSA, all Snowden has to do is to let it all out to the Obama administration on the quiet.
If the above was true, then you have a very worrying situation as this would transcend simple institutional rivalry, but indicate that Institutional loyalty was no longer national but falling along party lines. Presumably with the CIA being Republican and the NSA, Democrat.
In other countries, such Institutional Partisanship are early indicators of State failure and instability.
You really would need far more than just one cause-celeb to seriously assert that any such division was happening and you would need to see social and political division in the US far greater than traditional democratic rivalry.