Swap FK ci_resource_groups to projects for LFK

What does this MR do and why?

Per &7249 (closed)

As part of our CI "decomposition" efforts we need to remove all foreign keys that are cross-database (ie. between the planned main and ci databases). We are going to replace them all with "loose foreign keys".

This foreign key have been determined to be safe for swapping to loose foreign keys per #348267 (closed).

@shinya.maeda All endpoints are authorized to access the project, thus the project record is not present, users request can't reach the to-be-deleted-rows. Example

Related issue: #348267 (closed)

Screenshots or screen recordings

These are strongly recommended to assist reviewers and reduce the time to merge your change.

How to set up and validate locally

Numbered steps to set up and validate the change are strongly suggested.

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.