Today is just for me to add a link for me to remember.
Below is a great summary of the issue and how it can be resolved when you try to build an ansible execution environment in a disconnected environment.
https://cloudautomation.pharriso.co.uk/post/ansible-builder-disconnected/