It's not clear why you insist that a wall must be 100% effective to be of value.
The Secret Service hasn't been 100% effective in protecting the President (Kennedy) - does that mean that the Secret Service protection is useless and should be disbanded?
It's not clear to you, because I'm not insisting that it can, will, or should be.