[FEATURE] *Trusted publisher - Long term solution*

[figueroa1395]

When trusted publisher was introduced (https://github.com/PowerGridModel/power-grid-model/pull/944) as the method to publish to PyPI, a patch (https://github.com/PowerGridModel/power-grid-model/pull/965) was necessary to make it work on main as on: release doesn't work as expected from GitHub Actions (see https://github.com/orgs/community/discussions/25281). The quick solution, was to move the standalone publishing workflow into ci.yml (https://github.com/PowerGridModel/power-grid-model/pull/965), but this is not an ideal one.

This issue serves the purpose of keeping track of this, while we come up with a better way to do it. One possible long term solution, could be to follow what is suggested in https://github.com/PowerGridModel/power-grid-model/pull/965#issuecomment-2824083090. But any other alternatives are welcome as well.