[enhancement]: explicit release workflow

### Is there an existing issue for this?

- [X] I have searched the existing issues

### Contact Details

_No response_

### What should this feature add?

I think we should move to an explicit pypi release workflow (e.g. one not triggered by magic branch names). Besides the increased safety of explicit releases, it means we can increment the version on main as we so please, avoiding confusion related to version numbers.

We can use `inputs` to provide a branch or tag name from which to build the release: https://github.blog/changelog/2020-07-06-github-actions-manual-triggers-with-workflow_dispatch/

@lstein @Millu what do you think?

### Alternatives

_No response_

### Additional Content

_No response_