Align open-telemetry-operator Helm Chart with Deprecated create-rbac-permission flag

[SergK]

Is your feature request related to a problem? Please describe.
The create-rbac-permission flag is deprecated as per discussions in open-telemetry/opentelemetry-operator#2588 and changes in open-telemetry/opentelemetry-operator#2787. This deprecation impacts the open-telemetry-operator helm chart, specifically the createRbacPermissions flag, which could affect the functionality of k8sattributes.

Describe the solution you'd like
To align the helm chart with the deprecation of the create-rbac-permission flag, it is essential to ensure the SERVICE_ACCOUNT_NAME environment variable is available inside the pod, as indicated by the source code in open-telemetry/opentelemetry-operator/internal/autodetect/rbac/check.go#L29 and the manager configuration open-telemetry/opentelemetry-operator/config/manager/manager.yaml#L55.

Describe alternatives you've considered
N/A

Additional context
Ensuring the SERVICE_ACCOUNT_NAME environment variable is set correctly is crucial for the functionality of k8sattributes following the deprecation of the create-rbac-permission flag.