Does waking up multiple times throughout the night seriously affect someone's health?

Absolutely. Interrupted sleep ("sleep fragmentation" in medical-ese) is a major source of health issues ranging from relatively simple headaches to very complex emotional/cognitive problems. As a matter of public safety, fragmented sleep can be the same as not sleeping at all--making the sufferer a danger behind the wheel of a car or at work. Get a diagnosis from a certified sleep physician!