ci: Run 'create-issues-for-failing-tests' on canonical master pipelines

What does this MR do and why?

I noticed we ran this job in the security mirror, which we shouldn't: https://gitlab.com/gitlab-org/security/gitlab/-/jobs/4370400156

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• I have evaluated the MR acceptance checklist for this MR.