The irreverent Scottish comedian tackles big themes like death, decline and the disappointments of m