Let’s be frank, traditional locks exist to keep honest people honest. It’s trivial to learn how to pick locks, there are YouTube channels dedicated to exactly that, and the tools can be purchased for very little upfront cash.
There is no such thing as a foolproof unpickable locks. Any lock that is designed to be opened will have vulnerabilities associated with it that can be exploited by somebody who knows how.
That said, smart locks are probably not much worse off in that regard. I think you can still use a manual key with some models, so that’s not really adding security, but rather convenience. For the ones that are 100% digital, the issue is just shifted to technical knowledge of the lock software and not the mechanical workings.
I’d say they aren’t any more or less secure, just another option that a determined thief can get past, either through skill or brute force if necessary.