Wondering if husband is up for delivery...

Ta
In the midst of our weekend childbirth prep class, and the hospital is pretty family-centric in terms of L&D. It's our first child for either one of us, and while I'm strangely not scared at all re labour and am looking forward to meeting our baby, my husband is starting to freak out like crazy.
It's as though I've suddenly turned into Zen Momma Earth and he's gone into Full Anxiety Mode 😂 He had no clue until today that fathers/support persons would be so involved - he told me tonight that he really thought he could just sit in the waiting room while I went through childbirth 😳 He was a trooper today in class, helping me with the breathing & positions, but he's a lot more squeamish than I and I'm now starting to wonder if I should even have him in the delivery room...I love him dearly and don't want him trying not to vomit/pass out the whole time I'm labouring. He barely made it through the birth videos we watched today...I want to maintain a calm & serene atmosphere during labour as I want to try a drug-free birth (which he doesn't get at all either). Anyone had a partner who was similar? What arrangement worked best for you during labour?