Provide context about why a cherry pick or revert failed

Closes #33178

See merge request gitlab-org/gitlab!19518