A new film reveals intimate truths about his life after The Beatles, from his years cocooning with family to a near-drowning – and the drugs bust that nearly ruined him ...