Fix/upgrade `pre-commit` config

[pamella]

Description: Describe in a couple of sentence what this PR adds

Fix/upgrade pre-commit config since it wasn't working.

Dependencies: dependencies on other outstanding PRs, issues, etc.

N/A

Merge deadline: List merge deadline (if any)

N/A

Installation instructions: List any non-trivial installation instructions.

Testing instructions:

• Run pre-commit install
• Check if the steps work properly.

Reviewers:

• [ ] tag reviewer
• [ ] tag reviewer

Merge checklist:

• [ ] All reviewers approved
• [ ] CI build is green
• [ ] Version bumped
• [ ] Changelog record added
• [ ] Documentation updated (not only docstrings)
• [ ] Commits are squashed
• [ ] PR author is listed in AUTHORS

Post merge:

• [ ] Create a tag
• [ ] Check new version is pushed to PyPi after tag-triggered build is finished.
• [ ] Delete working branch (if not needed anymore)

Author concerns: List any concerns about this PR - inelegant solutions, hacks, quick-and-dirty implementations, concerns about migrations, etc.