Update tooling

[sentrivana]

Problem Statement

A lot of our tools are pinned because we needed them to support old Python versions. We can now update again on the sentry-sdk-2.0 branch.

Solution Brainstorm

• see what dependencies we've pinned in the various requirements.txt files and try removing them
• also check the dependabot config
• also check Makefile, tox.ini and github CI yaml files.

### Tasks
- [ ] https://github.com/getsentry/sentry-python/pull/2690