insights: validate query runner is actually reporting errors

Created by: leonore

after working on #39873 I have a feeling that we might not actually be reporting error metrics.

doing a quick search on grafana doesn't trigger the metric to pop up, and there's no data for the operation.

/cc @joelkw @felixfbecker @vovakulikov @unclejustin