The door is effectively unlocked. Anyone walking past can open it. With a deadbolt key in the lock, even a locked door is only a turn away from open.
The whole key ring is exposed. House keys rarely hang alone. The same ring usually carries the car key or fob, a garage key, a mailbox key, sometimes office or building keys. One mistake can expose several locks.
Keys can be copied or photographed. Someone does not have to take the keys to cause a problem. A key can be photographed in seconds, and a clear photo can be enough to cut a copy. The keys go back in the lock, and nobody knows.
The address is attached. Keys in a door are, by definition, keys with an address. A key lost on the street might belong to anyone; a key in a lock belongs to that house.