[CI] ScoringIT class failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #7109 / release-tests
• elasticsearch-periodic #7102 / release-tests
• elasticsearch-periodic #7095 / release-tests
• elasticsearch-periodic #7081 / release-tests

Reproduction Line:

./gradlew ":x-pack:plugin:esql:internalClusterTest" --tests "org.elasticsearch.xpack.esql.plugin.ScoringIT.testDisjunctionScoringMultipleNonPushableFunctions {p0=term(content, "fox")}" -Dtests.seed=BA2ACA26D0FC1E58 -Dbuild.snapshot=false -Dtests.jvm.argline="-Dbuild.snapshot=false" -Dlicense.key=x-pack/license-tools/src/test/resources/public.key -Dtests.locale=ewo-CM -Dtests.timezone=America/Chihuahua -Druntime.java=24

Applicable branches:
8.x

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

org.elasticsearch.xpack.esql.VerificationException: Found 1 problem
line 2:9: Unknown function [term], did you mean [trim]?

Issue Reasons:

• [8.x] 4 consecutive failures in step release-tests
• [8.x] 2 consecutive failures in pipeline elasticsearch-periodic
• [8.x] 4 failures in class org.elasticsearch.xpack.esql.plugin.ScoringIT (3.5% fail rate in 114 executions)
• [8.x] 4 failures in step release-tests (100.0% fail rate in 4 executions)
• [8.x] 4 failures in pipeline elasticsearch-periodic (80.0% fail rate in 5 executions)

Note:
This issue was created using new test triage automation. Please report issues or feedback to es-delivery.

[elasticsearchmachine]

Pinging @elastic/es-analytical-engine (Team:Analytics)

[fang-xing-esql]

@carlosdelest Could you help to take a look at this test? term is under snapshot, could it be the reason?