I dont know where the heck you come up with your interpretations but Hey Jude was written as comforting song to Lennon's son during their divorce. Original title had been Hey Jules.
Let it Be is a song of hope. Not heroine.
When I find myself in times of trouble, mother Mary
(heroine) comes to me,
speaking words of wisdom, let it be.
And in my hour of darkness she is standing right
(heroine)in front of me,
speaking words of wisdom, let it be.
Let it be, let it be, let it be, let it be.
Whisper words of wisdom, let it be.
And when the broken hearted people living in the world agree,
there will be an answer
(heroine), let it be.
For though they may be parted there is still a chance that they will see,
there will be an answer. let it be.
Let it be, let it be, .....
And when the night is cloudy, there is still a light
(heroine), that shines on me,
shine until tomorrow, let it be.
I wake up to the sound of music, mother Mary comes to me,
(heroine again)
speaking words of wisdom, let it be.
Let it be, let it be, .....
bro don't be furious about stupid inclusion of word heroine .and keep in mind that Lennon was a heroine addict when this song was released.