Picard dies, naturally, for good and peacefully this time, with his crew at his side having made a difference and saving his son. He closes his eyes and wakes up to find himself a younger man... a Captain again on the Enterprise D bridge. Basically a version of the ending of Titanic (hey I liked that part!)
The Titan is trashed so her crew transfers to a new Constitution-III class ship... the USS Enterprise NCC-1701-G. Seven of Nine becomes Captain of it and before she heads off on her mission of exploration, she is greeted in her ready room by Admiral Janeway, telling her how proud she is of her.
RIker and Troi reconcile. He is promoted to Admiral and given oversight of Starfleet Exploration.
Worf and Raffi are put in charge of a task force to find out where else the Changelings have infiltrated the Alpha Quadrant.
Lore becomes a hybrid of Lore-Data, and the most human first generation Soong-type android. He's basically a new person. He and Geordi reconcile (presuming Geordi has blamed himself for Data's death for decades and advocated the synth ban like some have speculated) and begin /resume a friendship
Shaw is banged up, but a proven hero once again and given a new command.
Jack Crusher returns to Chateau Picard with his mother and finds Picard's belongings,his inheritance (passed to Jack). Series ends with Jack holding his combadge. It's ambiguous, hinting he may be rethinking joining Starfleet (without a clear commitment either way... better story that way).