My understanding of fail forward as applied to d&d is as a technique where at least some failures (maybe sometimes all) become successes with a complication.
So in d&d if you rolled a failure on your check to pick the lock, then you actually pick the lock and some complication occurs, be it...