Fifty-somethings in the room, be honest: how many of YOUR PARENTS got into Star Trek around the same time you did?
Okay, I'll bite (I'm 52 - saw the TOS third season first run - at least that's my earliest memory of episode watching I remember - I was 6 at that time).
Actually, my mother and father were part of the group that saw "The Cage" pilot at the preview house Desilu booked to gauge audience reaction. Her memories from that viewing included EVERYONE in the test group laughing when Mr. Spock appeared as she felt the pointed ears looked ridiculous; and also (no lie); she thought having a woman as second in Command was ridiculous too. (She wasn't against Women's Lib per se; but no, she didn't think a woman should be second in Command of a military space ship (which is how the ship and crew seemed to her.) She was mildly interested though and when STar trek finally made it on to the air, she caught a few episodes; and as I was growing up, I was interested in NASA and the space program (and manned Moon shots); so she was the one who first turned the TV to 'Star Trek' one night, and I was hooked.
As to my father, I found out they got invited to see the Star Trek pilot because he knew on of the carpenters who worked on construction of the sets; and money was tight, so to him, it was a free 'movie' of sorts; and my mother was complaining he didn't take her out much anymore after I was born, etc. He found the whole thing ridiculous, (but he was never into science fiction; he preferred cop shows and comedies.)
Still, I agree with you in that 'Star Trek' (despite GR's later insistence that 'Star Trek' was 'always about social issues') had as many more 'out there' and sometimes ridiculous episodes; then the ones with either a good literate plot/and or a social commentary.
That why I laugh when some fans try to claim (about TOS) -- "Star Trek was NEVER about action/adventure; and was ALWAYS 'socially relevant...'; as that ISN'T true. There's plenty of episodes where 'action/adventure' is the drux of the story <-- And nothing wrong with that (IMO).
BTW - I love TOS. IMO for me it's still the BEST series in what has become 'the franchise' - and yes, it like everything else was never perfect; but I take the good, the bad, and the ridiculous as part of the whole entertaining package - and I love it for what it actually is, and not what GR (and some more modern fans who take some entertainment TOO seriously) likes to claim it is.
That why I feel 'Star Trek' (2009) and 'Star Trek Into Darkness' are a good, fun, and entertaining update/modernization of old school TOS because both films DID do a good job of incorporating everything that made the original TOS enjoyable for me over the years.