Add comprehensive release process documentation

[vhaasteren]

Description:
While enterprise has automated PyPI releases via GitHub Actions, there is no clear documentation about how the release process works or how version management is handled. The current setup uses setuptools_scm for automatic version generation, but this isn't documented.

Proposed Solution:

• Create a RELEASE.md file documenting the fully automated release process
• Explain how setuptools_scm works for version management
• Document trusted publishing setup
• Include troubleshooting information
• Add links to the release documentation in existing docs

Benefits:

• Clear understanding of the automated process
• Documentation of version management approach
• Easier troubleshooting when issues arise
• Better maintainer onboarding