HN has fads like everything else. If this were 10 years ago they'd be asking about MongoDB. 5 years ago they'd be asking if the Blockchain could power their search engine. Now they want an AI search engine.
It was not designed for "AI usage" or as a "AI database"
SQlite is from 2000 and is more comparable to a single file postgres/mysql database.
It's also on literally billions of devices including whatever you're reading this on.