Emit low cardinality mcp notification span names

[Lms24]

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

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

Fallback constant: MCP_NOTIFICATION_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-3415