If something such as a feeling, effect, or impact wears off, it gradually disappears or becomes less strong over time.
Example
A: You seem a bit tired now. Weren't you really excited earlier?
B: Yeah, the excitement wore off once the event was over.
Tell it apart
The anaesthetic wore off.
My shoes wore out.