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.
There is at least the possibility to get a good traditional lock that is trusted by organisations that value security and has the interest in getting security solutions that genuinely defeat intrusion.
Anyways, the general idea should be to have a house lock that is better than your neighbors, and that is sufficient for most purposes.
I'd say the main purpose of any kind of lock (meaning the weakest link all around your house - strong front door won't help if the kitchen door to the patio is always unlocked) is to be less appealing to burglars than the next house. At least that is how it works in Germany: Burglars drive around in vans, typically in daylight, sometimes walk around houses, looking for opportunities. If they see a cracked window, or an easy to access balcony door without too much exposure, they'll give it a go. If that balcony door (I lived in a flat with that setting) has a big iron grating installed in front of it, they'll move on and look for another place to rob, not because they couldn't maybe find out that the iron grating is not attached very well, but because it looks like too much effort to even invest the time to find out.