The Rocket Man singer revealed he was recording a new song when he began to weep after contemplating how much time he has left on Earth