Qt's site does seem to be trying to scare you into believing that you can't possibly comply with the LGPL and you really really should buy the commercial license, for your own sake.
LGPL isn't really that onerous though..
However, new modules in Qt 6 and any rewrites of modules Qt 5-> 6are now GPL, which is rather copy-left and will spread to the rest of your code.