In an interview with 60 Minutes, the Beatle talks about worrying, songwriting, and how even John Lennon was insecure