No, twist of fate doesnt work on celestine standing back up. The rare rules (
pg. 363) say :
REPOSITIONED AND REPLACEMENT UNITS
Some rules enable units to teleport or else be repositioned and set back up on the battlefield. Other rules enable units to removed from the battlefield and be replaced by a new, full-strength unit, which is then set up on the battlefield. If a rule causes a unit to be removed from the battlefield and subsequently set back up, the following rules apply to it:
.
.
.
8. Any rules that unit was being affected by when it was removed, and which would continue to affect it for a specific duration (from abilities, Stratagems, psychic powers, etc.) continue to affect that unit until such a point as they would normally have no longer applied. For example, a unit that was within range of an aura ability when it was removed would no longer be affected by that ability if it was set up outside of that aura’s range, whereas a unit that was being affected by a psychic power that lasted until the end of that turn would still be affected by it until the end of that turn.
Note that points 5-8 do not apply to any unit that has been set up because it is replacing a destroyed unit (including units set up via a rule that instructs you to remove a unit then set it back up at its full starting strength). These rules represent new units joining the fight, rather than the existing units being repositioned on the battlefield.
Miraculous Intervention is a rule which replaces a destroyed unit with a new full strength unit.
Miraculous Intervention:
The first time CELESTINE is destroyed, roll one D6 at the end of the phase instead of using any rules that are triggered when a model is destroyed (e.g. Sacrifice). On a 1, this unit counts as having been destroyed for the purposes of Sacrifice; on a 2+, set CELESTINE back up on the battlefield as close as possible to where she was destroyed and not within Engagement Range of any enemy units, with all her wounds remaining.