If you're doing a reboot, then yes. If you're just playing to the past, then you might as well give the people who are paying what they want. Star Trek really isn't science fiction anymore, it is its own thing with its own rules.
The thing is, I've always thought you could do both - wonder and realism.
I've sometimes seen the choice between realism and wonder presented as a dichotomy. But looking at say that Stargate SG1, which was not perfect, but used natural wonder to it's advantage (i.e. the imperfect but wonderful black hole episode, or the engineering solutions to their war with the Goa'uld), I don't see why you can't have wondrous sci-fi and also keep most things fairly realistic. I really don't. That is why I wonder why the writers actually need to 'ignore the majority of science ficiton'.
Deep time, the potential age of some of the civilizations out there, are themselves a wonder, without the need for embellishment. Things like the actual engineering of thrusters to attach to an asteroid and prevent collision can be presented as interesting enough.