Multiple Integration tests are failing due to Python and Botocore dependency

SUMMARY
Multiple Integration tests are failing in the CI due to updated Python 3.12, Boto3, Botocore, and AWS Cli versions.

ISSUE TYPE
Bug Report
COMPONENT NAME
ansible-core package installation/dependency resolver

ANSIBLE VERSION
milestone

PYTHON VERSION
3.12

COLLECTION VERSION
latest (main branch)

OS / ENVIRONMENT
Github CI

STEPS TO REPRODUCE
Run the integration tests in the CI with the test-all-the-targets label, and the tests will fail at (for example):

• name: Generate RSA keys
  ^ column 3

fatal: [testhost]: FAILED! => {"changed": false, "details": "Error while setting attributes: /tmp/ansible.r4oww_5wssh/id_rsa: Operation not supported\n", "gid": 0, "group": "root", "mode": "0600", "msg": "chattr failed", "owner": "root", "path": "/tmp/ansible.r4oww_5wssh/id_rsa", "size": 3357, "state": "file", "uid": 0}

EXPECTED RESULTS
All CI is passing

ACTUAL RESULTS
https://github.com/redhat-cop/cloud.aws_ops/actions/runs/26964407613/job/79563120674
PR : https://github.com/redhat-cop/cloud.aws_ops/pull/180

Start by running the integration tests with the test-all-the-targets label and inspect the failing GitHub Actions job linked in the issue. Review the ansible-core package installation and dependency resolver behavior around Python 3.12, Boto3, Botocore, and AWS CLI versions; done means the integration tests and CI pass.