tracing: add trace events to all the http endpoints

The goal is to create a similar event to [SampledQuery](https://github.com/cockroachdb/cockroach/blob/e9add29fc21da9683dcd76cbf47fcc261367302d/pkg/util/log/eventpb/telemetry.proto#L33), but for http calls.

Goals:
1. Capture overall latency.
2. Capture request details. To help understand what options were requested to understand why a request behaved a certain way.
3. Record all failures.
4. Capture stats for individual calls in the http endpoint to understand what is the cause of the latency.
5. Be able capture these events in splunk/snowflake/etc.. other external observability systems to be able to monitor and troubleshoot the http endpoints.

Related issue: https://github.com/cockroachdb/cockroach/issues/94250

Jira issue: CRDB-30270

Epic CRDB-32402