The Beatle also talks about worrying, songwriting and how even his famous bandmate was insecure