Yeah it works -- only on some dead pixels though, not all of them. You can rub it with a finger just fine, just put a piece of paper over it first so that you don't ruin the monitor's finish. I personally removed a dead pixel on a monitor in the office that way, but a while later, I tried doing the same thing on another monitor but it didn't work. Oh well.
I don't really know why it works, but my guess is that sometimes if there's a particle that's loose and just happens to be on the transistor, you're basically moving it away, while other times, if the particle is stuck (i.e. embedded) in the circuits, then no amount of rubbing is going to fix the dead pixel.
As far as I'm concerned, "dead" and "stuck" mean the same thing -- nonfunctioning sub-pixels, whether bright or dark. I don't buy into how manufacturers put up a good dead pixel policy then say "oh, 'dead' means dark-only". Especially since the more widespread TN panels tend to have bright dots, not dark dots. This is because TN panels are actually normally white, i.e. when no voltage is running through them (as is usually the case when they don't work), they are clear. For IPS and MVA panels, the opposite is true, so those tend to have dark dead pixels instead. At any rate, rubbing should (or could) work for either type of defect, whether bright or dark.