Automate check for new pipelines and metadata update
# What does this PR do?

This PR adds a script to check that new pipelines are properly added in `update_metadata.py` so that we properly update the table that is used by the frontend to determine which pipeline tag to use by default for a given model.
This check is added as part of the `repo-consistency` job.

Of course there were some new pipeline tags missing, this PR adds them too.
_The documentation is not available anymore as the PR was closed or merged._