Simplify/refactor release workflow for the core package

[shadeMe]

The current release workflow is error-prone (cf #7783) and very cumbersome. We should simplify it by moving in the direction of the process used in the core integrations.