It's an interesting question...
DuckDB is a library. Just like SQLite is a library.
It's not designed for concurrent queries, clients connecting to a database, etc. I know there will be companies built around that problem space.
If "serverless" database is a thing, is there a category of software that is "production-less"? :)
(The above is a joke, lol.)