‘The feelings of despair that I was experiencing were so strong. It was excruciating to sit with that,’ said the 40-year-old singer