Former Sky News presenter Dermot Murnaghan has said he "fell through the gaps" with his prostate cancer diagnosis, calling it a "massive wake-up call".