In practice, I hardly ever find tearing to be a real problem. It's a very nerd-centric problem. End users don't know what it is and don't really care, IMO.
They may not know what it's called, but it does look sloppy... Depending on the speed of your PC and video adapter, it can look *very* visually distracting.