Former Beatle was 'humbled' by vision while on Dimethyltryptamine, though it 'didn’t turn my life around'