It may be the following reasons:

Normal coconut water should be light and slightly sweet. If the coconut water is salty and sour, the coconut has gone bad.

I suggest you cut it open next time you buy it. Milky white is normal. If coconut meat turns yellow, it may go bad.