The musician detailed a turning point during the Beatles' rise to fame and how he navigated life under the spotlight