Update CI/CD jobs used for determining pipeline name
What does this MR do and why?
We remove the deprecated CI job names that we use to determine pipeline types.
It follows what we've been doing in https://gitlab.com/gitlab-org/quality/engineering-productivity/snowflake-dashboard-sql/-/merge_requests/47.
MR acceptance checklist
Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.