This term is usually used when someone had just heard some good - often unexpected - news.
Dave: Guess what?
Mike: What?
Dave: When I went to get us tickets to the 'Stones gig, the girl at the ticket booth was an ex girlfriend of mine in college!
Mike: So? Big deal!
Dave: She gave us 'Platinum' grade seats and we only paid for 'Silver'! How do you like that!
Mike: That's excellent! My nipples are hard, dude!
While our lifespan is the number of years we will live, our healthspan is the number of healthy years we will have and our sexspan is is the number of years we will continue to be healthy enough to continue having an active sex life.
A lighthearted reaction upon receiving disappointing news of some sort. Usually something that isn't a particularly a big deal, esp. when it primarily affects someone else - sort of a mild schadenfreude. Sometimes doubled or tripled, and possibly said in a sing-songy voice for added comedic effect to imitate a muted trumpet, which is how the meme originated.
You didn't get any napkins with your takeout pork fried rice? Womp womp.
A phenomenon in film/television series, most notably streaming series, where the main premise is drawn out to such a point that it takes an entire season or more to get the parts of the series the audience is actually interested in seeing.
For example, if a series is titled "Surf Dracula," a majority of viewers would tune in expecting to see Dracula surfing by the first or second episode. However, the entire first season would instead be tedious padding and backstory before finally ending with Dracula surfing in the last five minutes of the season finale.
I watched "Smallville" on Netflix the other day. Dude, it was ten seasons of filler before he finally flew! Major Surf Dracula Syndrome!