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.