More musing on the season, series, problematic nature of the coda.
So, Zora was self-aware right? Does it seem even slightly okay then that they sent her to lie abandoned in deep space until the events of "Calypso"? That being said, she might not have been there all that long in the end - the 1,000 years talked about in "Calypso" might include actually the time jump for S3 depending on the interpretation of things that you take. We'll never know, since the writers declined to explain anything properly in favour of leaving it all cutesy and mysterious (read: annoying and confusing).
Adira Tal. Much was made initially when they were introduced that they were a human joined with a Trill symbiont. That plot point just vanished, eh? Much like Adira seemed to regress once Gray got themselves a separate body - Adira thereafter was written like they didn't, in fact, have Tal's lifetimes behind them and instead as something closer to a non-binary version of S1 Tilly.
Additionally on that - virtually every character had their screen time sacrificed on the altar of Michael Burnham The Ever Right™, but a special mention if I may for Rayner. It took until right near the end of the season but they did figure out how to write him. If any characters deserve a spinoff series or even just a one-off adventure he's one of them. Much like Anson Mount's Pike in S2 he felt like an orphan parachuted in from a better show.
You wonder what this show would have been like if Bryan Fuller had kept the showrunner job. As it was all that was left from his time at the helm was the wildly impractical Klingon makeup, a budgetary black hole from set construction and a location shoot in Jordan for a five minute scene, and Michael Burnham.