Make multi-version upgrades DB migration job required to pass

What does this MR do and why?

• Updates DB migration test for multi-version upgrades to be required to pass
• Documents job description and troubleshooting guidance

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

How to set up and validate locally

• Guidance how the test can be run locally https://gitlab.com/gitlab-org/quality/pg-dump-generator#migration-upgrade-testing
• Snowflake metric of the test stability - https://gitlab.com/gitlab-org/quality/pg-dump-generator/-/wikis/home#metrics

Validation

Test has been monitored for 4+ weeks and there were no cases when it failed unexpectedly. See Monitor multi-version upgrades test stability (gitlab-org/quality/quality-engineering/team-tasks#1922 - closed) for more details, specifically gitlab-org/quality/quality-engineering/team-tasks#1922 (comment 1828206842).

Changes in this MR to rules were validated in !147662 (closed) -> https://gitlab.com/gitlab-org/gitlab/-/jobs/6458341976 ✅