In my opinion this is like criticising Picasso's paintings for not being anything close to as realistic as photos.
Fine, it's a valid opinion to dislike either for those reasons, but for many people it was, and is, art that's exciting in part because of its perfect non-perfection.
I think with lyrics most people don't give them a second thought and don't realise what the person is singing about. Most people can't even tell you which instrument is being used in a part of a song.
This is different to visual art - most people can play spot the difference no problem, but with audio most people are deaf to the details, and the lyrics!
Eg. My Sharona - most people don't realise it includes the lyric "I always get it up for the younger kind"....
I wish people would sing about the mundane rather than sex, drugs and crime all day.
I think A Day in the Life fits that requirement.
And "someone's knocking at the door, someone's ringing a bell, do me a favour, go to the door, open it and let them in"...
It's like he was trying to lyricise everyday activities. Very odd.
I say this as a penniless musician in contrast to the very successful Mr McCartney (who plays bass lines like he's playing the tuba, very clever)