Revered musician opens up to presenter Zoe Ball about his health, sobriety and extraordinary career for the BBC Eras podcast