Didn't realize the chief of security (Shaxs) is a Bajoran. I like the light, cheerful atmosphere of the trailer and presumably show, general missions and adventures don't seem to deviate much from classic Trek.
----------------
I miss the good old times when ST was completely substance over style and full of reason like - among other stuff - exploding consoles or floor plates crew members have to remove manually so the ship can launch a torpedo (TWK).
www.youtube.com/watch?v=v7Xmh-weq1g&t=2m13s
It's legit to point out the nonsense of the whole rollercoaster thing, I don't like it either, but at least people don't fucking die because of it, and it does not needlessly extend the time you need to get combat-ready. Apparently these issues are not a problem for you while the rollercoaster is a game changer, I sense obvious double standards here.
Trek materials can be incredibly resilient, especially when combined with force fields (Structural integrity field). Archer and Reed survive the blast of a mine 20 to 25 metres away in space using rather thin, reinforced shuttlepod hatches without any kind of force fields for protection.
The direct depiction of automated drones is not a contradiction, it was long OVERDUE. Let's not pretend robots are a big deal in a world full technological marvels such as space ships, beaming, ftl drives, insanely advanced computers and the whole lot of other space magic. Hell, TOS (and DS9) introduced completely automated vessels, cargo drones and robot ships, what's keeping them running?
DS9 shows some automated military hardware:
TNG has the special probe from "Interface" remotely controlled by Laforge and equipped with mini tractor beams which can do basically everything.
https://memory-alpha.fandom.com/wiki/Interface_probe
The Ent-D can clean itself, we never saw how.
TWK is definetly not the answer to everything (see above, stupid torpedo bay design for instance), the movie or many elements of the movie are actually quite dumb tbh.
Exocomps are described and presented as very sophisticated, fast problem solvers with the ability to learn, we have no reason to believe DOT-7s and drones from Discovery equal them in terms of capabilities and performance.
ST is based on live-action shows and films, it should go without saying that they were (and still are) limited by budgetary and practical/ CGI constraints.
Ronald D. Moore acknowledged this kind of limitation:
https://memory-alpha.fandom.com/wiki/Memory_Alpha:AOL_chats/Ronald_D._Moore/ron053.txt
It's about firefights, but basically covers it all ("one of those things that we tend to slide by").

ST is full of continuity problems and retcons, DSC+ era Trek is actually restrained in that regard. The hate comes from fans or "fans" who feel offended because the vicious Kurtzman gang has the audacity to ruin their headcanons, plus some shitty youtubers and whatnot inventing and spreading bullshit for clickbait.