Add additional sections to telemetry.mdx

[mkcp]

Feature Description

Our telemetry docs do an effective job at identifying the key metrics operators should be tracking and suggested alerting thresholds. However, we currently provide a table with every metric after that without groupings. The metrics in this table are second or third order - likely to be used for debugging after a problem has been identified and needs to be narrowed down. They're the metrics that are specific enough to provide operators insights into how Consul's being used.

In order to make this better, we should categorize the remaining metrics by the workloads they're used in. Often this is captured by the second token in the metric name, e.g. ACLs: consul.acl.etc.

Use Case(s)

We should group metrics by workload where applicable so we may provide guidelines on grokking them, alerting on them, debugging with them, and getting insights from them.

[mkcp]

Blocked by #9197

[mkcp]

It would be neat to sort all of the metric names alphabetically and trim a lot of the redundant language we use in the help strings: mainly "This" over and over.

[jsosulska]

Reopening this issue to add additional context. The original ask is still valid:

• Group metrics logically, (re)move the massive table
• Provide "Why Important" for each grouping
• Provide "What to Alert On" for each grouping
• Recommended Debugging & Insights