The expression is frequently used in American English in informal contexts. When you tell someone that a project is dead in the water, what you are suggesting is that it is a failure. No matter what ...