Did all those people really have to die during the Biblical flood?

Respectfully, was it really fair? I mean no disrespect, I'm just curious.

The Christian faith has been a huge part of my up bringing but science has taught me to think differently.

I guess you could say I am a "spiritual agnostic" if that makes sense.