[Detection Engine][ES|QL] - ES|QL support for partial results

[yctercero]

Summary

ES|QL will support partial results by default in 8.19/9.1. We need to ensure that we are dealing with these changes appropriately.

Requirements

• Rule shows as partial failure if there are partial results, rule error clearly communicates partial results and what shards were not searched.
• Test for possible false positive scenarios with ES|QL. For EQL, it was clear that we cannot support partial results for sequence queries, it's not as clear with ES|QL.

[elasticmachine]

Pinging @elastic/security-detection-engine (Team:Detection Engine)

[elasticmachine]

Pinging @elastic/security-detections-response (Team:Detections and Resp)