[CI] TopTests class failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic-platform-support #11453 / rhel-9_platform-support-unix
• elasticsearch-pull-request #105561 / part-3
• elasticsearch-periodic #11481 / concurrent-search-tests
• elasticsearch-pull-request #105414 / part-3
• elasticsearch-intake #31487 / part3
• elasticsearch-pull-request #105302 / part-3-fips
• elasticsearch-pull-request #105221 / part-3
• elasticsearch-periodic-platform-support #11437 / almalinux-8_platform-support-unix
• elasticsearch-periodic-platform-support #11437 / rocky-9_platform-support-unix
• elasticsearch-intake #31382 / part3

Reproduction Line:

./gradlew ":x-pack:plugin:esql:test" --tests "org.elasticsearch.xpack.esql.expression.function.aggregate.TopTests.testAggregate {TestCase=<far future dates>}" -Dtests.seed=8586DE445F6C714C -Dtests.locale=tr -Dtests.timezone=Europe/Rome -Druntime.java=25

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: 
Expected: <DOUBLE>
     but: was <DATETIME>

Issue Reasons:

• [main] 22 failures in class org.elasticsearch.xpack.esql.expression.function.aggregate.TopTests (2.4% fail rate in 921 executions)
• [main] 13 failures in step part-3 (2.3% fail rate in 558 executions)
• [main] 4 failures in step part3 (2.7% fail rate in 150 executions)
• [main] 2 failures in pipeline elasticsearch-periodic-platform-support (33.3% fail rate in 6 executions)
• [main] 14 failures in pipeline elasticsearch-pull-request (2.5% fail rate in 556 executions)
• [main] 4 failures in pipeline elasticsearch-intake (2.7% fail rate in 150 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)

[alex-spies]

@nik9000 , this seems to be related to #133760. Somehow we got the aggregator strings wrong for TOP. Could you please have a look?