It doesn't generate as much marketing buzz on its own as a Lastpass or a 1Password does, but too many people have too much stake in their passwords for them to even consider a less secure solution solely based on marketing.
I'd prefer a CLI based password manager for it's flexibility.
My guess is that the lack of browser integration (with extensions) that helps people autofill on specific sites/domains is what keeps it from being recommended as much as LastPass or 1Password.
What it's still missing is the possibility to have (almost) concurrent edit on the database, if you sync that on the cloud. Talking about the KeepassXC browser, they are close to a release where multiple users will be able to edit the database without breaking everything.