Why do splinters hurt so much?

Sensitivity. Typically splinters occur in areas (hands) and layers of your skin rich in nerve supply, irritation of these nerves can be quite painful.
Location. We usually get splinters on our fingers. On our fingers are probably the highest concentration of nerve endings on our bodies. This translates into increased pain. That may be the best explanation.