I do not believe DS9 will be destroyed, but if it is, I would be okay with it.
It's not the station's destruction I would object to (well, maybe the way it went out, having difficulty with three attackers when its held off a fleet before), but the wiping out of the vast majority of the cast. Killing Kira, or Ro, or Kas, or Bashir, or Serena, or Quark (maybe?), or any two of those plus a new cast member (I like Chief Blackmer) would be one thing - and I'm completely comfortable having Vaughn not come back - but all of them at once? Be one loooonely DS9 series, just Sisko and Prynn.
I could easily envision a scenario where Enterprise
stop the attack on DS9...but a great portion of it has been destroyed or will be destroyed. The crew evacuates the station and watches it blow up, similar to how Sisko witnessed the desturction of the Saratoga
Sisko witnessing the Saratoga
exploding and there's absolutely nothing he can do about it? Now THAT is pain.