Not having seen the movie yet, obviously, it's impossible to say for sure, but it looks like the destruction of the Enterprise in "Beyond" is serving a similar story purpose to the destruction of the Enterprise in "The Search for Spock", namely to put Our Heroes at a tremendous disadvantage, in an extremely precarious situation, from which they will have to escape. You know... danger, action, suspense, constantly raising stakes. All those things that are fun in movies.
The destruction of the Defiant towards the end of DS9 was used to similar ends, to show that the entrance of the Breen into the war had turned the tides against Our Heroes, making it all the more important that Damar and his rebellion be made to succeed.
Really the only time the destruction of a Hero Ship seemed tacked on and pointless was in Generations, since it happened way towards the end of the film and the two main characters (Picard and Kirk) didn't even find out that it had happened until well after the threat had been resolved (except Kirk, who didn't find out all, because he was dead due to bad screen writing).
As long as the death of the new Enterprise is more exciting and dramatically relevant than that (and it sure looks to be) I'm not seeing a problem.
The destruction of the Defiant towards the end of DS9 was used to similar ends, to show that the entrance of the Breen into the war had turned the tides against Our Heroes, making it all the more important that Damar and his rebellion be made to succeed.
Really the only time the destruction of a Hero Ship seemed tacked on and pointless was in Generations, since it happened way towards the end of the film and the two main characters (Picard and Kirk) didn't even find out that it had happened until well after the threat had been resolved (except Kirk, who didn't find out all, because he was dead due to bad screen writing).
As long as the death of the new Enterprise is more exciting and dramatically relevant than that (and it sure looks to be) I'm not seeing a problem.