Is your feature request related to a problem? Please describe

As part of working on search level star-tree stats as part of #18707 and #19017, discovered that we don't capture search query failure stats.

We should ideally have the following search level stats to capture failure counts as well for observability use-cases.

• search.query_failed
• search.startree_query_failed

Opening up this issue to see if we have any other stats gaps that we would want to include as well.

Describe the solution you'd like

PR to introduce stats: #19209

Related component

No response

Describe alternatives you've considered

No response

Additional context

No response