SSG is the right call for content that changes rarely and is the same for every visitor: marketing pages, documentation, blogs, course material, and product catalogs. These benefit most from the speed, the low cost, and the strong SEO that comes from shipping complete HTML that crawlers can read without running JavaScript.
It is a poor fit for highly personalized or real-time content. A user dashboard, a stock ticker, or a shopping cart that differs per session cannot be baked in at build time. For those you reach for SSR or CSR, or you statically generate the shell and hydrate the dynamic parts on the client.
The main trade-off is build time and staleness. A site with tens of thousands of pages can take many minutes to build, and any content edit means a rebuild. Modern frameworks soften this with Incremental Static Regeneration, where the first request after a page's cache window expires still gets the cached page and triggers a fresh render in the background, which is then served statically, so you get fresh content without rebuilding the whole site.