[Milestone] Metrics Trace Explorer

[ale-cota]

Problem

Our current experience is focused on a metrics-first exploration. Customers a more flexible and complete way to explore data and find relevant traces. No need to have 2 different experiences.

Solution

Enable trace-first use-cases like search for tags set on traces and not metrics.

### Tasks
- [ ] https://github.com/getsentry/sentry/issues/65000
- [ ] https://github.com/getsentry/sentry/issues/65001
- [ ] https://github.com/getsentry/sentry/issues/65002
- [ ] https://github.com/getsentry/sentry/issues/65003
- [ ] https://github.com/getsentry/sentry/issues/65004