It's not about the resolution, it's about the sound they make as the tube powers up, and the smell, and the slight whistle in operation. They're also have excellent refresh rate and add no latency to the incoming signal.

I still have a CRT for my SNES. It's not in the best of shape (bit of burn-in from a previous owner), but it makes me happy every time it turns on.