Does this sounds like a horrible way of dying ?

If the water pressure didn't break your neck or cause sufficient skull fracture, then you would drown to death, which is a horrible way to go.