[Request] update advanced settings tier selection documentation

[vitaliidm]

Description

After elastic/kibana#196390 is merged, we also support this setting for ES|QL rules

Background & resources

• PRs: [Security Solution][Detection Engine] fixes ES|QL data tier filter from adv settings kibana#196390
• Issues/metas:
• Point of contact: @vitaliidm
• Test environments:

Which documentation set does this change impact?

ESS only

ESS release

8.16

Serverless release

n/a

Feature differences

n/a

API docs impact

n/a

Prerequisites, privileges, feature flags

request for the rest of rules: #5483
Docs PR: #5860
We just need to remove ES|QL as not supported, leaving just ML