Convert Remaining Bazel git_repository rules to use http_archive #3469
Description
Description of the task
After the migration to Bazel 8 in #3459, we audited the dependencies we use in our project. One thing that was noticed was that we frequently used the git_repository (and similar) bazel git rules to include external bazel packages into our project. The issue with this is that the git related rules are not supported by bazel's caching mechanism (repo caching). This means that the repos are re-fetched and re-built every time they are referenced. See https://bazel.build/rules/lib/repo/git#git_repository
Instead, we should replace all remaining instances of new_git_repository or git_repository with http_archive or the bazel module-based rule archive_override.
Acceptance criteria
- No more usage of non-caching rules