Rework Release Pipeline

[Maleware]

Description:

We want the release pipeline to behave and work the same as the dev pipeline.

To be refined.

[NickLarsenNZ]

This was done as part of #913.
Yet to be tested during the 24.11 release. If all is well, we can delete the old workflow.