In my Army days those working the intel agencies were vetted to the point where this would likely never happen. I recall a form that listed all the un-American organizations, and this list was looooooooooooong. One simply could not be associated with any of them. Not to mention being a druggy, homo or have any record at all.
If something like this did happen, action would be quick and the media would never know.
I recall a guy that got caught smoking pot, he was immediately assigned to a DA infantry unit in ‘Nam.