One of the BBC's top news executives resigned today in the wake of a damning report into the BBC's decision to drop a Newsnight investigation into Jimmy Savile's sex abuse.