Improvements to pipelines deletion

Improvements to pipelines deletion

1. Only delete scheduled pipelines. This will keep the pipelines from MRs and the merges into main intact. Those might be helpful for future reference / audits.
2. Only delete orphaned child pipelines, where the upstream pipeline was deleted.