I don't want to be in the room while my wife is having our baby because I have a weak stomach
You don't need to be there I suppose. Do you feel like it will be a problem if you're not?
No, but I am curious and I want to see the process but I am unsure if I can handle it.
I get being curious about the birth process, but it's okay if you can't handle being in the room. You'll just make more work for the staff if you end up passing out or getting sick. Consider staying in the waiting room during the actual birth.
I probably will pass out so I should stay away, but I want to learn more about human bodies.
You can learn about it on the internet. There are even videos of the process.