Well considering the Biden administration, like the Trump administration before it, said the information should not be disclosed because it would do significant harm to national security. The mention of national security makes me think the issue here is multi faceted.
National security is not a get-out-of-democracy-free card. There has to be some way for public opinions about the CIA to loop back around to the congresspeople on the security council, otherwise the system won't work.
The likely possibilities are, they all agree it’s necessary for reasons we don’t understand so they condone it—or, the power of the executive branch is diffuse and doesn’t always emanate from the Oval Office. I.e., the so called deep state, career bureaucracy and momentum hold more sway.