chore: Add integration test requirement for Ansible Galaxy major version updates

Spun out of https://gitlab.com/gitlab-com/gl-infra/gitlab-dedicated/instrumentor/-/merge_requests/4314#note_2193486104

• Adds a new rule in the renovate-versions-dedicated.json Renovate preset file to require an integration test for Ansible-Galaxy major version updates.
• This rule is triggered when a major version update of an Ansible Galaxy dependency is detected.
• The rule adds a label to the pull request to indicate that an integration test is required.
• For non-major version updates, also includes a note in the pull request body to remind developers to perform a review app deployment to ensure that the upgrade works as expected.