I know.
I’ve experienced frozen pipes. Many times. I was raised in the Midwest.
I’ve never had a flood.
The vast majority of people will be just fine.
There is plenty of information on the ‘net for those who are frightened.
You were raised in a place where people were prepared for cold weather so odds are that even if you did have a pipe freeze it would be at the junction where the pipe passes from the inside of the house to the outside, and you had plumbers who could tell where the break was just by the sound. These people are totally unprepared.
Frozen pipes were never a problem in New Hampshire either where we lived.