Display CI status on group details page

What does this MR do and why?

Reinstated the CI checkmark on the group details page.

Resolves the issue #20450

Screenshots or screen recordings

Query Generated (for database review)

SELECT
  COUNT("latest_ci_pipelines".*)
FROM (
  VALUES (278964),
    (443787),
    (250833)) project_ids (id)
  CROSS JOIN LATERAL (
    SELECT
      "ci_pipelines".*
    FROM
      "ci_pipelines"
    WHERE
      "ci_pipelines"."project_id" = "project_ids"."id"
      AND ("ci_pipelines"."source" IN (1, 2, 3, 4, 5, 6, 7, 8, 10, 11)
          OR "ci_pipelines"."source" IS NULL)
    ORDER BY
      "ci_pipelines"."project_id" ASC,
      "ci_pipelines"."id" DESC
    LIMIT 1) AS latest_ci_pipelines

Query Analyses: https://console.postgres.ai/gitlab/gitlab-production-ci/sessions/18058/commands/59914

Note: Discussions on query iterations can be found here.

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.

Related to #20450