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.