David Letterman backed his successor Stephen Colbert and suggested CBS canceled The Late Show because he was 'always shooting his mouth off' about Donald Trump