The Church Committee is an excellent example of what happens when Congress tries to reign in the intelligence community.
(1) Nobody goes to jail.
(2) The intelligence agencies hire lots of lawyers to make sure they are in technical compliance with the law.
(3) The nasty stuff is shuffled off to new agencies or departments (which may themselves be secret).
(4) Compartmentalization and secrecy is increased until it is “safe” to bring the nasty stuff back into the old agency.
(5) What you are left with is an army of intelligence agency employees who have no idea about the bad stuff and can swear “nothing to see here”.
Total joke.
You just hit a grand slam summarizing that worthless Church investigation. He used it to run for president and the media pretended the Democrats were piggybacking off Watergate to fight corruption.
It produced nothing, but the press still cites it.