The destruction of the NCC-1701 was seriously dramatic climactic and apoplectic. Shocking too.
Every show and movie after that featured the destruction of the main spaceship, but none caused such impact.
I agree entirely with this. It's the only time destroying the hero ship has worked. It almost worked in DS9 with the Defiant, but then they ruined it by giving them an identical replacement a couple of episodes later. It definitely did not work with the destruction of the Enterprise-D, surely one of the greatest narrative blunders in the history of the franchise, and the less said about the Abramsprise the better.
Actually, thinking about it I suppose it worked with the Enterprise-C as well, because there are few TNG episodes more moving than "Yesterday's Enterprise".
Also the balls of Harve Bennet: if the movie hadnt been lucrative, the studio wouldnt order a ST4 and the ending of the series would have been horrible: the Enterprise destroyed, Spock brain-damaged, Kirk and the gang's careers in Starfleet ruined, etc
My feeling has always been that The Search For Spock was written and filmed as though it could have been the final instalment of Star Trek if it needed to be.