Agree good first episode.
A more recognizable Starfleet , not the bitter cynical, miserable organization of season 1. (although that's just the set-up, we're about to lose it to a possible totalitarian future Starfleet)
New interesting looking (not just CG cloned) ships. New Borg ship and take on the Queen (with a possible new motive) and new Stragazer hero ship look terrific.
Main characters seem likable now. I get they were going for the dissfunctional, broken, antithetical Trek crew (is what made them somewhat interesting), yet having them finally get there. I guess really makes a difference.
Especially having Raffi, Rios, Picard back in Starfleet. (for now)
And Q set up stakes seem hi, and compelling so far.