The presenter, 50, became emotional while discussing the loss on his podcast with longtime friend and co-host Declan Donnelly