lol, ah i know the feeling of bad sunburn - i have red hair and ill get burnt just even thinking about being in the sun.
aloe vera does work, but getting it straight from the plant stinks, is sticky and leaves a green gross film on your skin, lol...i find that this green aloe vera gel stuff works wonders, i think its made by banana boat.
if ive been in the sun too long and i can feel the sunburn setting in, when i get home ill layer the gel on constantly. like every 15mins apply a thick coat and just let the skin soak it in, if you treat it quickly it wont end up as painfull or bad and can even prevent it from peeling at all.