Document release automation workflow

Create comprehensive documentation for the release process automation.

Include:
- How the GitHub Actions workflows work
- Repository dispatch mechanism
- Formula update automation
- Manual steps still required
- Troubleshooting common issues