No, that isn't the point at all. The point is that if you were homosexual, a foreign intelligence agency could discover that and blackmail you to reveal secrets. This doesn't apply so much if you are openly gay vs in the closet but I doubt they made those kinds of distinctions.
RE: On the perceived omnipotence of the US Federal Government