The top executive in charge of CBS News resigned on Monday amid President Trump’s intensifying political pressure against the news