The country singer was poised to be the next big thing, but his struggle with mental illness left him lost, alone, and on a path of self-destruction