Remember that I mentioned moderation though? A glass or two of OJ, lemonade, tea, coffee, or seltzer a day isn’t going to materially impact your health assuming you’re not diabetic, and practice good oral hygiene. There are also many worse things for your teeth than seltzer, such as potato chips, and poor oral hygiene. If most of what you’re drinking is water, don’t sweat the glass or two of something other than water. Unfortunately too many poeple drink very little unadulterated water, and it does impact their health.
Moderation is the key.
Acidity of most beverages on its own is usually not problematic as saliva (buffered at 6.5 pH) rapidly restores normal pH. It does become an issue if the salivary glands are damaged (as in the case of meth users) or stomach acid comes into contact with teeth.(severe acid reflux or bulimia) However these cannot be considered normal.
The number one cause of dental cavities is always sugar.
('Notable cases' include recorded death.)
That said, the amount of ways your body adapts to osmotic balance problems is in the dozens, so poisoning your body with water, while possible, is hard to the tune of it requires something like drinking 20 liters of water in less than an hour. I mean, it seems to be possible but I cannot imagine succeeding at that even if I'm trying. That's 2 full buckets (and that's just LD50, as in, if you're >70kg it's more than that).
There is an exception: purified water. You cannot drink mineral-poor* or distillated water safely in even small quantities. Why not ? Because that will locally, suddenly and very strongly disrupt the osmotic balance in what you bring it into contact with. It probably not kill you (not without repeated application), but it may cause serious issues in your mouth, throat and stomach. It should also not be used to make coffee or tea and drunk, that merely lessens the effect it doesn't stop it.
* mineral-poor water is something used in chemical and medical laboratories
I wonder what is the pH of glass of carbonated water with a squeeze of lime?