In short, a lack of evidence of showing the “causation” of weight gain from diet coke does NOT mean that consuming it in huge amounts is a good idea.
Moderation still matters when it comes to losing weight and opting for water remains the healthier choice overall.
Reference article: Altered processing of sweet taste in the brain of diet soda drinkers by Erin Green and Claire Murphy, 2013.