Ok, probably I misinterpreted the meaning of “tracking failure”.
I thought it was something like: piwik.php script is called correctly but the INSERT statements into the tracking tables run with some errors and… this is a tracking failure.
Indeed, it is more like a handful of common error with tracking API requests that Matomo can easily detect e.g. tracking requests are sent to a siteID that doesn’t exist (anymore)