No season is perfect, but there's really no better place to leave them than laughing together at that poker table in Guinan's bar with the Enterprise-D safe in the fleet museum. It's hard to imagine that another movie could end any better than that. And if you can't meet or exceed where things were left, why bother? Don't pick it up again if you can't leave it better than you found it.
Could the old crew make appearances in the future? Sure, I wouldn't mind briefly checking in on occasion in another show, like the show the S3 ending teases. Perhaps they receive a request from Data with Soji. Or Riker pulls some strings at Starfleet to open a door for the new Captain. Maybe Picard calling his son. Nothing that changes the endings we got for the TNG crew, just....elaboration on where we left them. I'd enjoy glimpses of their continued presence in this era. But they should not be headliners again, let their book be finished with season 3.
