Consider switching to common-pipeline.yml

Summary

This template now uses multiple components from the common pipeline via individual include statements. This issue proposes switching to the common-pipeline.yml template directly and disabling any unwanted jobs using the appropriate *_DISABLED variables. This should make ongoing maintenance easier and will ensure we have access to all of our standard pipeline jobs as and when we need them in our Terraform module repos.

Acceptance criteria

• Review current pipeline configuration and list dependencies on common pipeline components.
• Test using the common-pipeline.yml with relevant *_DISABLED variables.
• Propose/implement the switch to the common-pipeline.yml in an MR if it is viable.