^^ It isn't just me. I vividly recall the reaction of many in the audience when the saw the Enterprise destroyed in The Search For Spock up on the big screen. A lot of people, including me, were visibly moved and bothered by it. Now flash forward some years to Generations when we witnessed the E-D being wrecked and I actually heard cheers and exclamations from members of the audience---quite a different reaction.
To be fair there's a world of difference between the events of The Search for Spock and Generations. In 1984, we had a fugitive crew and the spanking new Excelsior taunting us as a possible replacement for our beloved Enterprise. In 1994, we were already on the Enterprise-D. We had all been down this road before. The only question was whether they painted an "E" on the current filming model or created a new ship? There was no suspense as to where they were going next with The Next Generation crew.
I feel the destruction of the Enterprise (it is every bit the 'Enterprise' to me that the original was and I love the original) and the death of Kirk in Generations was a turning point for the franchise. It was the point where I began to lose my personal connection to Star Trek.