The troubled musician was a genius whose work was the envy of generations of fellow artists. Fiona Sturges pays tribute, and recalls her encounter with Wilson where he told her about his fear of failure, his abusive father, and the voices in his head