From reading the thread, it looks like they are dodging the question of what features will be restricted to the commercial license versions ("case-by-case basis" apparently). They keep repeating "no change to people using the app currently", "no change to self-hosting right now", etc., but it doesn't inspire confidence.
I would recommend to read the thread and ask questions there if you have any, but I would definitely have a backup plan ready.
The KeePass ecosystem is awesome and it's what I use, it's local-first and you can use Syncthing to have passwords across many devices. KeePassXC for desktop (+ browser extension if you need it), KeePassDX on Android (w/ Syncthing-fork), and if you use iOS, you have KeePassium and Strongbox (w/ Synctrain). The iOS apps are more limited, blame Apple for their restrictive ecosystem and high entry fee.