I think it's fine on Lower Decks since they make it funny. I hope no one thinks we need another episode like the one from TNG season 1 where Data does the deed.
As a Gen-Xer who got plenty of in the 90s and early 00s, horny sci-fi works in moderation, but, yeah, LD could afford to dial it back a smidge. I like the dynamism of that show, and the writers have no shortage of imagination. Let’s stifle that urge. It’s like the fart joke of this generation.
Ace Trekkie here, you're not alone! The decon scenes in Enterprise especially just make me cringe so hard, there's just way too much horniness on that show for my tastes.
Although it's probably realistic though. They're alone in space on the road for months at a time. There are other no other human ships that far out at that point in time so it's basically just them and the people on board.
If Roddenberry had his way TNG would been way hornier, some summarizations of his early pitches basically had the Enterprise D being a giant polygamous orgy off duty, and definitely earning that D in their registry. To say nothing of sexual counselors and holodeck progams that would make Quark's holosuites blush.
Star Trek: Prodigy. It’s the Nickelodeon show for kids who have never watched Star Trek. It features a cast of new alien species who find a mysteriously abandoned prototype Starfleet ship. The ship mistakes them as a batch of Starfleet recruits, and a holographic Janeway teaches them the basics of the Star Trek universe and things like the Prime Directive.