A tight pimp is someone who is just a smooth operator. A tight pimp has got his pimp all together, operating succinctly with other parts of his game: flow, mojo, clothes, limp, etc.
"Oh that dude Kyle, yeah he be a real tight pimp."
"Mike, you know what? You be a bombass tight pimp daddy."
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.