Question

Why does water go stale overnight

Answer 1

But that's not what makes old water taste stale. For that we can thank carbon dioxide. After about 12 hours tap water starts to go flat as carbon dioxide in the air starts to mix with the water in the glass, lowering its pH and giving it an off taste.