Same story with Snowden, a low-level contractor who was apparently able to walk away with the whole store. Love him or hate him, he's not the Agency's real problem.
Dropout was also convenient because it applied to both Manning and Snowden.
You have to assume that US enemies already more than what Snowden knew even before he released it.
My experience with DoD contractors is that they are the worst sort of government contractors. They'll do anything to get extensions, add-ons, and other lucrative contracts while providing the absolute bare minimum necessary to meet the strict letter of existing ones.
As long as our government contracting system is run as a font of graft and corporate welfare, all the policies, procedures, and regulations in the world aren't going to stop the Snowdens and Private Mannings of the industry from having access to things they may not need to have access to.
My guess is that compartmentalization was given as an excuse in order for the government to expand power during a time of 'crisis'. Today they lie to you about what the NSA does, 10 years ago it was lying to you about what caused 9/11, including lying about the memo, and the training exercise.
Remember that before the memo and the training exercise were public knowledge that 'no one could have predicted 9/11'.