As DNI, she brought candor and integrity to intelligence – but in a White House that prizes loyalty, truth became a liability