Run most FOSS jobs in FOSS pipeline

What does this MR do and why?

Run most FOSS jobs in FOSS pipeline

Note that this also removes clusterwide-db for FOSS because it's not passing for EE anyway.

Also note that this can make the pipelines run much more FOSS jobs because previously we might only run partial FOSS jobs like build-assets-image, but now when we run it will run all the corresponding FOSS jobs.

We can tweak the rules accordingly in the next iteration. For this iteration this is focusing on bringing everything over, and it should avoid missing jobs unless there's a good reason like clusterwide-db jobs can't pass anyway.

How to validate

• rspec:artifact-collector as-if-foss grabbing FOSS coverage data: https://gitlab.com/gitlab-org/gitlab/-/jobs/5969480118
  • We can see the coverage data have FOSS project id (13083) as the suffix.
• FOSS pipeline did run all the variants whenever all the labels are used: https://gitlab.com/gitlab-org/gitlab-foss/-/pipelines/1144603292
  • pipeline:run-all-rspec pipeline:run-single-db pipeline:run-praefect-with-db

How to validate for security projects

See https://gitlab.com/gitlab-org/security/gitlab/-/merge_requests/3824 and the pipeline: https://gitlab.com/gitlab-org/security/gitlab-foss/-/pipelines/1149716780

Related to #412717 (closed)