We know from the trailers that Team Picard steals the Titan in a version of Star Trek III's heist (beyond them running from Today's episode). I bet they end up trashing the Titan by the end to save Picard's son, also a Star Trek III callback kinda. Maybe the Enterprise D crew dies in the process, or some of them anyway.
But anyway I bet the show ends with a new, Constitution-III class USS Enterprise NCC-1701-G. It's why I think they're "early retiring" the Odyssey class 1701-F. On the Enterprise-G, either Seven will be Captain or Shaw ill be (and the Titan crew, including Seven, will transition to it) and Janeway will make her cameo there, to see Seven off. This is how I think the show ends.
Enterprise G. Captain/Commander Seven of Nine, and Admiral Janeway in the ready room telling her star pupil how proud she is of her.