Geez, if George Martin and Paul McCartney were heaping praise all over an album, and I didn't "hear what all the hoopla is about", I would not admit it in public. ;-)
I'm in the minority (though not alone) in considering Sgt. Pepper's Lonely Hearts Club Band album the most over-rated album in Pop music history. Both Rubber Soul and Revolver are better albums. IMO.
I love how Pet Sounds ends: with the sound of a far-away train clattering down the tracks, a distant dog barking in response. When I was a little kid, we lived a few blocks from the train tracks that run alongside San Fernando Blvd. in the Valley, and I awoke every morning to that exact sound. If that ending doesn't give you a clue as to what the album is about, and the emotional response the music is intended to evoke in the listener, I don't believe I'm interested in knowing you. No offense intended.