I've always interpreted those failures in fiction as akin to an apoc-world failure.
The MC move is harm or the consequences of time passing, do the determination that help/desperate measures are needed to try again.
The odd exception that feels like a 'no, but here's another opportunity' are either MC generosity on a fail or a particularly harsh partial.

I've always thought the key to the boringness of the D&D whiff was the ability to just try the same thing again in the same circumstances. Fiction doesn't tend to do that.