Can be safer. Can be worse.
A poorly configured self hosted vaultwarden can be a major security issue.
A properly configured one is arguable safer than hosting with a 3rd party. Lastpass taught me that one.
If you configure it to where it's not exposed to the web, and only accessed through a VPN, like Tailscale. It can be quite robust.