SSIS failure flow error. The decision after a sequence container failure does not proceed with the correct flow
I would look at the event handlers (Package explorer tab shows this nicely). Something in there might be tamping down the failure or the DWH_STAGE container might have an explicit return status.
Something is off because a minimal reproduction works as expected