Provide better compilation and cache stats to remove compiation rate limits

[stu-elastic]

Ingest pipelines submit their scripts in ways that may be asynchronous to the user such as during startup or when adding new beats configs. Similarly, watcher scripts may need compilation at times that aren't clear to the user.

Breaking: We should remove all compilation rate limits and instead provide cache stats for users to correctly size their cache.

Progress:

• Add time series metrics (PR: Script: Time series compile and cache evict metrics #79078)
• Deprecate context caches and default to general cache (Merged) 7.x: Script: Deprecate script context cache #79508
• Ensure rate limiting removed for system contexts (Merged) 7.x: Script: Opt-out system contexts from script compilation rate limit #79459

PR for 8.0 for deprecation and system context rate limiting removal: #79453

[elasticmachine]

Pinging @elastic/es-core-infra (:Core/Infra/Scripting)