It’s important to note that when you type something into Google hoping to see your website in the search results, you’re not actually looking for your website.
You’re looking for a page on your website.
That’s an important distinction.
If Google doesn’t know about the existence of the page you’re trying to rank or thinks it doesn’t deserve to rank, then it won’t show up anywhere that matters in the search results.