opentelemetry-instrumentation-pymemcache: semantic convention stability migration

[tammy-baylis-swi]

What problem do you want to solve?

Implement semantic convention stability migration for opentelemetry-instrumentation-pymemcache for OTEL_SEMCONV_STABILITY_OPT_IN mode database and (if applicable) http, gen_ai_latest_experimental.

Describe the solution you'd like

Implement the semconv opt-in feature for pymemcache

Describe alternatives you've considered

No response

Additional Context

Part of #2453

Would you like to implement a fix?

None

Tip

_{React with 👍 to help prioritize this issue. Please use comments to provide useful context, avoiding +1 or me too, to help us triage it. Learn more here.}