(Pias)Contemplating pain, death and suffering, rock’s former prince of darkness finds euphoria despite it all, on an album of contagious joy and thrilling melody