Stargate SG-1 has been a tremendously entertaining TV show.
Heroes I and Heroes II dealt with the issues of press freedom and public accountability cleverly and skillfully, first as comedy, then as tragedy.
The really jarring note was the rah-rah flag-waving recruiting film toward the end of Part II. This was the series producers' most obvious payback for DOD "technical assistance."
Such "technical assistance" is of course a euphemism for the military's misuse of taxpayer dollars on self-serving PR. The US Navy similarly misused taxpayer dollars during the production of "Top Gun."
This sort of "you scratch my back and I'll scratch yours" relationship is of course exactly why a real Stargate must not be kept a secret from those footing the bill.
The tired cliches about "public panic" voiced by every bureaucrat and milicrat character in Hollywood SF films made since the 1950s are unmitigated nonsense.
A nation's political and military officials withholding such information from a nation's citizens, is like a doctor withholding a patient's medical condition from a patient. The patient is the client. He is footing the bill. The information was bought and paid for, by him. The information belongs to him, not the doctor. The doctor has no right to withhold the information from him. The doctor has no right to argue that that "it's for his own good." It's simply not his call.
By the same token, information surrounding something like the Stargate may not be withheld from a nation's citizens, who bought and paid for it. The information belongs to them, not government officials. Government officials have no right to withhold the information from the public, by arguing that "it's for their own good." It's simply not their call.
The power struggle between NID and USAF is a red herring. They are both government entities. They both have their own narrow interests.
The real issue is whether members of the public, who paid for the information, are getting what they paid for.