Over a 60-year career, the singer-songwriter and ‘Toy Story’ composer has chronicled America with a sharp eye and unrivalled wit. Zoë Beaty talks to the writer who has delved into ‘the insecurities, the depressions and the difficulties’ on his creative journey