A cloud-based identity and access management service for securing user authentication and resource access
Even SharePoint Administrator does not grant access to all sites by default, you still need to add yourself (or the relevant user) to non-public sites. In your scenario, if it's a single site that's causing the issue, simply add (invite) the user therein.
If the issue affects multiple sites, you can use SharePoint Online PowerShell, the PnP module or the Graph API to grant access in bulk. Let us know if you need such examples.