The icon, who has sons Zachary, 14, and Elijah, 11, with husband David Furnish, said he doesn’t like talking about his own mortality, but was still taken by surprise when he “lost it”