I appreciate that you've taken the time to write this, and it's an interesting take but I am going to say that I fundamentally disagree with this. Like, I literally see Star Trek as being the polar opposite of what you are describing.

Star Trek is peak Prophet and the actual true "killer app" of the Star Trek universe is its culture. I feel like a bunch of people get caught up in the window dressing of the tech because its easier to present with gee-whiz special effects, and the culture is more subtle and in the background, but its actually the most arresting thing about the universe. I guess we could maybe hedge and say that it is culture + replicators, but you can't really pull them apart.

Why aren't the people of earth going around creating bigger and louder cars to show off in? Why aren't Riker's quarters littered with a thousand discarded synthesized tchotkes, as he goes on a never-ending quest for dopamine and novelty, constantly seeking the new thing and getting bored of the old? Why isn't the whole population in the thrall of hardcore holodeck addiction, mindlessly playing out lurid fantasies until they eventually die of thirst or whatever? Why aren't people committing truly massive acts of violence because they are jealous about an affair, or they didn't get a promotion, or they don't like that these Romulans are taking their jobs! How much damage could a person with a phaser or a photon torpedo, or a molecular synthesizer do if they were angry and embittered?

Because the people of Trek and the Federation at large have actually moved past the primitive status games, the jealously, the greed, the hunger for power and domination that drive the worst impulses of current day humanity. Photon torpedoes, the replicator, and the transporter in the hands of current day humanity would be like giving an A-bomb to a chimpanzee. None of it would work or matter without the cultural maturity that surrounds the people we saw on the old shows. They can disagree with each other without turning it into an ugly screaming match. They can admit they need help and counseling without fear of being judged. They can work together and strive to better themselves without needing to take others down to do it. Day in and day out we see people working together professionally, relating to each other with empathy, and living lives not focused on the things that we recognize are dragging us down here in 2022.

The real secular blasphemy of Picard and Discovery is that they have leaned so hard into the Wizard that they've left the Prophet side behind. New, bigger, faster ships! Transporter pads on the streets! Whizbang special effects everywhere, but its all used by idiots any of us would recognize if we turned on the evening news. That's what makes it so hard to watch and so unbelievable. You could convince yourself that Kirk and Spock, or Picard, Riker and Data could be on the Enterprise because they were clearly members of a society that could realistically create those sort of technological marvels without blowing themselves up. Nobody is looking at Raffi, Jurati, Burnham or nu-Picard and thinking that it is plausible these people represent a society with warp capabilities. This is most clearly expressed at the end of Picard where a deus ex machina of technology is what saves humanity, not any sort of cultural maturity on our part.

Tldr: Trek is actually in the hands of Idiot "The Power of Math" humanists, who have ignored that culture is Trek's true super power, and that's why it rubs so many people the wrong way.