The irreverent Scottish comedian tackles big themes like death, decline and the disappointments of middle age in her stand-up special filmed in Bristo