Should cornrows hurt?

No. A cornrow is attached along its whole route, so the hairline and the first few pickups take the most pull. Pain, stinging, a headache, a tight or tented scalp, or small bumps mean it's too tight: ask for those rows to be loosened or redone straight away rather than waiting for them to settle.