Revert "Merge branch 'create-downstream-pipeline-in-same-project' into 'master'"

This merge request reverts !20930 (merged) since it was potentially causing significant CI issues with multi-project pipelines:

1. #195705 (closed)
2. #195767 (closed)