If you're using ansible-navigator with Red Hat Ansible Automation Platform 2, then a number of Ansible Content Collections with many modules are included in the ee-supported-rhel8 automation execution environment container image that it can use to run playbooks. If you're just trying to use the Ansible Core 2.13ish ansible-playbook command from RHEL 9, then yeah, the local system just has the modules in the ansible.builtin Ansible Content Collection unless you can get more from other places on the system like rhel-system-roles.
If you're using Ansible 2.9 or earlier from, say, RHEL 8, then that's before the Ansible Core / Ansible packaging changes upstream and you'd have the old "batteries included" model with a large set of packages pre-installed.
If you were connected to the Internet, in theory you could get more (unsupported) collections from Ansible Galaxy, but I wouldn't expect or count on that for an exam environment.
