Prophets cannot predicted. Beyond the fact that they want Sisko alive.
But why would they spare Kira and Kasidy from meeting death on the Xhosa
only to kill them shortly afterwards when Deep Space 9 is destroyed? It doesn't make sense.
Hard to tell assuming the Station is not completely destroyed maybe they only wanted one of them dead and they would both be dead in case number one.