Emit low cardinality messaging span names

[Lms24]

Ensure messaging spans emit low-cardinality span names when span streaming is enabled.

Span name rules: https://getsentry.github.io/sentry-conventions/names/#messaging

Fallback constant: MESSAGING_SPAN_NAME_FALLBACK in packages/core/src/tracing/spans/spanNames.ts

Part of #22350 — remember to check traceLifecycle and keep the existing name for static mode.

[linear-code]

JS-3413