Wear out basically mean something has been overused. It can be anything. A car, clothes, people, a pen etc etc.
Wear off is not something that i can think of being used other than when someone might say to someone who is too drunk 'The alcohol will wear off soon' or some medication will 'wear off' after a while.