Add details on release candidate tagging to RELEASE.md

The `./contrib/tag-release.sh` currently supports a major-minor-patch version tag only. Should a maintainer want to create a release candidate to ensure the release process runs as expected, they need can manually tag and push and the CI will still respond as expected.

We might consider removing the tag release script in the future given it merely performs a few checks before tagging.