I mean, it's still a Kurtzman Trek show.I'll be very, very let down if Season 1 ends with some "epic stakes" finale. The whole point of this show, after all, is to watch characters grow. Part of that is (presuming they still do intend this to be a multi-season show, and not a one-and-done) that they face a relatively minor antagonist in Season 1, building up for bigger and badder things in later years.
Question is mostly HOW this epic stake will be implemented - e.g. I thought SNWs season 1 finale Romulan Invasion was okay, mostly because it was still a character episode (the Gorn invasion was more iffy).
I think DIS season 3 is still the absolute only live-action streaming finale without an epic mcguffin threat.