That's the problem with Hollywood writing.
They want everyone to be excited and so they have to keep one-upping themselves with superlatives. The biggest threat. The GREATEST. Bigger than anything ever! Something that was in the works for aeons! OH DEAR GODS HELP US IT'S SO BAD!
...but then they have to let 20 randos bitchslap it around, and of course everything has to be wrapped up in sunshine and rainbows within the scope of 3 patches, preferably without endangering any marketable character types that they've invested design and VA money in. So nothing ever actually threatens ANYTHING.
I mean yeah yeah we all now Captain Picard is going to survive the episode because there's more show after, but COME ON. This is just getting old.