How Google discovers URLs
Google finds new URLs through internal links from existing pages, external backlinks, XML sitemaps, and (less commonly) direct submission via Search Console. Internal links are the dominant discovery channel for most sites; sitemaps are the reliable backstop.
If a page has no internal links and isn't in your sitemap, it's an orphan, and Google may never find or rank it.