"I said ‘Yes’ to every support slot. Halfway through, the drinking caught up with me," says songwriter Nick Carpenter, who went through a crisis of conscience to get to new album King of Having Fun