feat(core): Deprecate Span.isSuccess() in favor of reading span status

[Lms24]

This PR deprecates Span.isSuccess() in favor of directly reading the span status via spanToJSON(span).status === 'ok' instead. There's no need for this API as it's just syntactic sugar around the status.

Seemed like we didn't even use this API in our SDKs - maybe some downstream SDKs use it but migrating should be very straightforward.

ref #10184

[github-actions]

size-limit report 📦

Path	Size
@sentry/browser (incl. Tracing, Replay, Feedback) - Webpack (gzipped)	77.35 KB (added)
@sentry/browser (incl. Tracing, Replay) - Webpack (gzipped)	68.66 KB (added)
@sentry/browser (incl. Tracing, Replay) - Webpack with treeshaking flags (gzipped)	62.3 KB (added)
@sentry/browser (incl. Tracing) - Webpack (gzipped)	32.67 KB (added)
@sentry/browser (incl. Feedback) - Webpack (gzipped)	31.13 KB (added)
@sentry/browser - Webpack (gzipped)	22.48 KB (added)
@sentry/browser (incl. Tracing, Replay, Feedback) - ES6 CDN Bundle (gzipped)	75.01 KB (added)
@sentry/browser (incl. Tracing, Replay) - ES6 CDN Bundle (gzipped)	66.65 KB (added)
@sentry/browser (incl. Tracing) - ES6 CDN Bundle (gzipped)	32.48 KB (added)
@sentry/browser - ES6 CDN Bundle (gzipped)	24.19 KB (added)
@sentry/browser (incl. Tracing, Replay) - ES6 CDN Bundle (minified & uncompressed)	209.83 KB (added)
@sentry/browser (incl. Tracing) - ES6 CDN Bundle (minified & uncompressed)	97.89 KB (added)
@sentry/browser - ES6 CDN Bundle (minified & uncompressed)	72.34 KB (added)
@sentry/browser (incl. Tracing) - ES5 CDN Bundle (gzipped)	35.49 KB (added)
@sentry/react (incl. Tracing, Replay) - Webpack (gzipped)	69.04 KB (added)
@sentry/react - Webpack (gzipped)	22.52 KB (added)
@sentry/nextjs Client (incl. Tracing, Replay) - Webpack (gzipped)	85.66 KB (added)
@sentry/nextjs Client - Webpack (gzipped)	49.81 KB (added)
@sentry-internal/feedback - Webpack (gzipped)	17.11 KB (added)