Yes it's probably normal. The act of being sick triggers a vasovagal response which slows your heart rate, drops your blood pressure and causes a transient lack of blood flow to your brain so you lose consciousness. It's usually harmless in itself but obviously you could injure yourself falling / aspirate some vomit if you're really unlucky.
But it could also be something to be investigated, so please don't take medical advice to not act from an anonymous forum where people have none of your medical history or access to referrals or context.
If it happens more than once, make an appt to see your GP - better they tell you there's nothing to worry about than Mumsnet.