It was nostalgia done right.
I had caught wind of potential spoilers weeks in advance of the episode, but wasn't entirely convinced by them. Not being US based, I couldn't have watched the episode when it was immediately released, so I happened upon the moment on YouTube before the forums lit up.
It was impressive, especially the reactions from the crew. Picard even seemed to regain some strength and vigour in that moment, whereas I was used to him seeming frail and downbeat. It was a total transformation in a very short space of time. Everyone was assembled, and it was just perfect.
I'm aware that Liz Kloczkowski and Dave Blass made some minute changes to the bridge, but I'm glad that there wasn't any temptation to visually update the design, as it would've lost a lot in the moment that the bridge lights came on.
I don't think that Star Trek could pull this off again, as no other ship (save the OG Enterprise) would hit the same. YMMV.
Voyager, Defiant, the NX-01 would be lovely to see in the same fashion, but it would be a case of diminishing returns after a while, but again...YMMV.