Only a robot can`t be afraid of anything.
I have been thinking recently of the idea you mentioned in your post, Wordno - that John was vulnerable, that is true, I think. On the one hand he had these leadership qualities and used to be an idol for boys in Liverpool, kind of being above them. On the other hand he desperately needed a soul-partner and hated loneliness. That`s why he left Cynthia, who he didn`t love (and I think had never loved), cause they were absolutely different people and he didn`t feel any bond to her, first of all emotional and intellectual. When he met Yoko he was overwhelmed how much alike they were. She was intellectual, radical, unusual, exotic, and I think very emotional. Like no other woman had been. "I had no doubt, I`d met the One," he said later. He wasn`t lonely any more.
But I don`t think he needed guidance, this is not true. He had been guiding himself and others all his life! So this idea of Yoko being as mother to him is nonsense. She was his equal, his true equal and he was impressed. It`s like it was with Paul. When John met him he was impressed. Maybe he even felt threatened by Paul`s talent but he asked him to join the band. It was not often that John met equals. So he sincerely fell in love with Yoko. Certainly he wasn`t afraid of Yoko but was connected to her by all these bonds. May Pang was just an ordinary girl. Yoko knew who to give to John for him to stay for a WHILE with.