It never showed failed sites, turns out the original search is:
| search status="Failure" | stats count
While our Status Overview showed sites being in state "Failed" instead of "Failure". Easy fix...
This is fixed now in version 2.9.2. Thanks for the clear report.
