Migrating to SSG is definitely one of the options!
I do wonder what other CMSes people do enjoy, though. My blog runs on Grav, a flat file CMS that still allows me to easily keep the content in Git, while also having some dynamic content and search (and optionally an admin UI): https://getgrav.org/
I feel like Grav was waaay ahead of its time. For the past year I've been chipping away at something inspired by it but written in Rust with KDL as the format for storing pages (and page data).
Hopefully I'll be able to release it by the end of the summer.
Grav was what convinced me that ultimately a CMS doesn't have to be married to a database, at least for what could be conventionally considered small websites.
I wrote a Wordpress to Grav exporter [1], which brings over most content (posts, pages, users, groups, attachments, some site-metadata, etc). I also wrote a Drupal 7 one, but I haven't touched that in a long while.
After exporting from either CMS, it's pretty close to drag/ drop onto the grav instance and everything should "Just Work (tm)".
I wrote about it in my blog [1]. It is an amazing tool with an unstable company behind.
Time will show us if the FAIR Package Manager will be able to improve the overall ecosystem status.
[1]: https://gioorgi.com/2024/liberta-come-aria/