tests: ansible galaxy unable to install collections with Traceback

# Bug report
Surfaced by jenkins daily tests on lxd_vm

Incompatible dependencies are installed due to our integration test setup that break along the same lines as this upstream/fixed issue
https://github.com/ansible/ansible/issues/79697

Looking at the pip packages in the test environment we see resolvelib at 0.8.1 which is greater than 0.6.0 as mentioned in upstream bug
```
me@cloudinit-0713-171640hsn6admb:~# pip freeze | egrep 'ansi|reso'
ansible==5.5.0
ansible-core==2.12.4
resolvelib==0.8.1
```

## Steps to reproduce the problem

```
CLOUD_INIT_OS_IMAGE=kinetic CLOUD_INIT_PLATFORM=lxd_vm CLOUD_INIT_KEEP_INSTANCE=1 tox -e integration-tests tests/integration_tests/modules/test_ansible.py::test_ansible_pull_distro
```
## Environment details
- Cloud-init version: 23.1.2
- Operating System Distribution: Ubuntu Kinetic ++
- Cloud provider, platform or installer type: lxd_vm

## cloud-init logs

[cloud-init.log.txt](https://github.com/canonical/cloud-init/files/12042806/cloud-init.log.txt)