The problem is wordpress does require a database server by default.

And reality is most blogs could be better served by a static web host platform with lower maintenance and less security risks.

Then the reality is that the blog should be migrated to fully static contents. You have generators, many of them (f.ex. Zola), where you write Markdown files, run a command and run `rsync` to your host.