Add new metrics about queue size and output workers to template

[simitt]

With #22215 additional metrics for stack monitoring are collected (queue.mem.events, output.elasticsearch.workers, output.elasticsearch.bulk_max_size). They should also be added to the template to allow to query by them.

this is targeting 7.14

[elasticmachine]

Pinging @elastic/integrations-services (Team:Services)

[graphaelli]

Let's also grab beat.info.version from #26214 while we're at it.

[jlind23]

Backlog grooming: @simitt is this issue still relevant?

[elasticmachine]

Pinging @elastic/elastic-agent-data-plane (Team:Elastic-Agent-Data-Plane)

[simitt]

For APM Server this is not relevant any more for APM Server; might still be interesting for other beats though.

[botelastic]

Hi!
We just realized that we haven't looked into this issue in a while. We're sorry!

We're labeling this issue as Stale to make it hit our filters and make sure we get back to it as soon as possible. In the meantime, it'd be extremely helpful if you could take a look at it as well and confirm its relevance. A simple comment with a nice emoji will be enough :+1.
Thank you for your contribution!