Understand that 'wear off' implies a change over time, not an immediate stop. The charm of the old house will wear off once you notice the creaky floors.
Pro Tip 2/3
Gradual Loss
It suggests a slow reduction, often unnoticed until much of the effect is gone. The scent of perfume will wear off throughout the day.
Pro Tip 3/3
Metaphorical Use
Can be used metaphorically to refer to emotions or abstract concepts. The aura of mystery around the celebrity wore off over time.