Central to the story is Capt Picard, whose consciousness is hopping between a number of fixed time periods like some kind of 24th century Billy Pilgrim. He's in almost every scene, but Patrick Stewart is up to the task, whether it be as a man full of confidence, of doubts, or seemingly bordering on senility.
A further benefit in connecting itself to the pilot is its ability to comment on TNG as a whole, in a way that's both reflective and contemplative.
It's sad to see a beloved show end production, but TNG's ending is perfect, drawing a knowing line under what's gone before whilst simultaneously looking ahead to the future. That duality is why I love re-watching AGT....