workflow:rules templates are now deprecated

from GitLab docs:

The workflow:rules templates were deprecated in GitLab 17.0 and are planned for removal in 18.0. This change is a breaking change. To configure workflow:rules in your pipeline, add the keyword explicitly. See the previous examples for options.

We need to search where Branch-Pipelines.gitlab-ci.yml or MergeRequest-Pipelines.gitlab-ci.yml are used and replace them with the corresponding contents of https://gitlab.com/gitlab-org/gitlab/-/tree/master/lib/gitlab/ci/templates/Workflows if appropiate.