Water sensor light

[NYBobby]

Have a 96 150 XRI EFI and was told the water sensor could be bad. Is the red light supposed to be on or off when everything is good? Tried searching internet but can’t seem to find anything on it. Any help is greatly appreciated!!!