A woman has died and a man remains in a critical condition after the pair entered the sea to rescue their dog.