‘I had no idea that I was that far gone’: Leon Harris opens up about incident that ended his TV career