> at which point you've reinvented either a static site generator ...

It doesn't have to be Astro though. You can build something super simple that just includes the header, footer, and nav. Leaving most of the site as plain HTML.

Yes; that's Eleventy. Or Hugo. Or Jekyll. They are extremely simple, without the bells and whistles of Astro.