Remove need to call gitaly in ProjectPipelineStatus

Closes gitlab-foss#52780

See merge request gitlab-org/gitlab!33712