After books on Lennon and McCartney, the author turns to the contradictory ‘quiet Beatle’ – whose acid tongue and sexual buccaneering coexisted with mantras and prayer wheels