Managing Postgres, even via containers is not so simple. Upgrades between major versions will still need a backup+restore for eg.

I run a single container Postgres for my homeserver, and have to deal with occasional issues that wouldn’t apply to SQLite (which I run as well).