I can't speak from experience per se, but it seems like theoretically the rate at which you experience these moments will reduce asymptotically towards 0 over the course of the rest of your life.

Ebbinghaus's forgetting curve suggests this.