1. Create virtual envirnment

python3 -m venv ~/venvs/ansible-core-2.16.14
source ~/venvs/ansible-core-2.16.14/bin/activate
pip install --upgrade pip setuptools wheel

Make sure virtual environment has no ansible-core if it has uninstall. 
pip uninstall ansible-core

2. Download rpm
mkdir /tmp/unpack_rpm;cd /tmp/unpack_rpm
curl -O https://download.eng.rdu2.redhat.com/rhel-10/nightly/RHEL-10/latest-RHEL-10/compose/AppStream/x86_64/os/Packages/ansible-core-2.16.14-1.el10.noarch.rpm

3. Unpack rpm contents

rpm2cpio ~/ansible-core-2.16.14-1.el10.noarch.rpm | cpio -idmv

4. cp all contents to virtual env 
site=$(python -c "import sysconfig; print(sysconfig.get_paths()['purelib'])")
cp -r ./usr/lib/python3.*/site-packages/* "$site"/

# install runtime python deps that rpm 
pip install jinja2>=3.0 resolvelib<1.1 packaging PyYAML cryptography


(ansible-core-2.16.14) [cloud-user@ocp-psi-executor-xl sap_july3]$ pip uninstall -y ansible-core
Found existing installation: ansible-core 2.16.14
error: uninstall-no-record-file

× Cannot uninstall ansible-core 2.16.14
╰─> The package's contents are unknown: no RECORD file was found for ansible-core.

hint: The package was installed by rpm. You should check if it can uninstall the package.
(ansible-core-2.16.14) [cloud-user@ocp-psi-executor-xl sap_july3]$ pip list ansible-core
Package      Version
------------ -------
ansible-core 2.16.14
cffi         2.0.0
cryptography 46.0.2
Jinja2       3.1.6
MarkupSafe   3.0.3
packaging    25.0
pip          25.2
pycparser    2.23
PyYAML       6.0.3
resolvelib   1.0.1
setuptools   80.9.0
wheel        0.45.1
(ansible-core-2.16.14) [cloud-user@ocp-psi-executor-xl sap_july3]$ pip uninstall ansible-core
Found existing installation: ansible-core 2.16.14
error: uninstall-no-record-file

× Cannot uninstall ansible-core 2.16.14
╰─> The package's contents are unknown: no RECORD file was found for ansible-core.

hint: The package was installed by rpm. You should check if it can uninstall the package.
(ansible-core-2.16.14) [cloud-user@ocp-psi-executor-xl sap_july3]$ ---> This means it is installed from rpm and not pip



(ansible-core-2.16.14) [cloud-user@ocp-psi-executor-xl sap_july3]$ ansible-galaxy collection list 2>/dev/null

# /home/cloud-user/.ansible/collections/ansible_collections
Collection                   Version
---------------------------- -------
community.backup_working     *      
community.kubernetes         2.0.1  
community.sap_infrastructure 1.1.3  
fedora.linux_system_roles    1.85.0 
kubernetes.core              5.2.0  
kubevirt.core                1.4.0  

# /usr/share/ansible/collections/ansible_collections
Collection                   Version
---------------------------- -------
redhat.rhel_system_roles     1.108.6
redhat.sap_infrastructure    1.1.3  
redhat.sap_install           1.7.1  
(ansible-core-2.16.14) [cloud-user@ocp-psi-executor-xl sap_july3]$ pip list
Package      Version
------------ -------
ansible-core 2.16.14
cffi         2.0.0
cryptography 46.0.2
Jinja2       3.1.6
MarkupSafe   3.0.3
packaging    25.0
pip          25.2
pycparser    2.23
PyYAML       6.0.3
resolvelib   1.0.1
setuptools   80.9.0
wheel        0.45.1