Im not really sure what to think of the first episode. Opinion with spoilers ahead:
Seeing the "crew" from season 1 on the Stargazer felt good, also having a proper space ship again. Guinan cameo was nice, too.
The return of the Borg was kind of meh. The Federation is worried enough to send a whole fleet of ships - as it should be - but then the people in command come up with the great plan of "talking". Opening fire and analysing the debris is what you do when encountering the Borg. (Pretty sure that's taught in lesson one in space combat tactics at the Academy.) Unless, there's another alien race in the very same sector from another dimension that you cannot kill on your own. Then, and only then, talking is permitted. (That's probably taught a bit later.) Also Star Fleet integrating Borg technology into their own ships while still being afraid of the Borg is so stupid that it is believable again. Humans tend to do stupid things like that.
The return of Q, oh my goodness. I hope it's really just to create another universe / timeline and the interaction with Q is limited, while the story progresses mostly without him. I think in TNG 6x15 "Tapestry", in which Picard died before, the interaction was also limited, and that episode was okayish. Meanwhile, the first association with Q's appearance I had was that of a Goa'uld System lord. (I'm looking at you Ba'al.)
Anyway, I'm somewhat intrigued and somewhat put off by the first episode. Let's see what episode 2 brings.