fully saturating a medium does not cause root rot. that's what you should do each time...  if not waiting long enough between irrigations, that could cause root rot. One time will not cause it.
There is more than one cause of interveinal chlorosis, so you may need to let it progress a bit more to confidently diagnose.
If it is Mg related, should see some spots coinciding with the chlorosis, which i don't see here.
Chlorosis at bottom (mobile) is a bit weird, but i guess it could be Fe deficiency -- this would be unusual.. trace element issues are usually a side effect of pH issues or nute-lockout. it's uncommon there's an actual, physical trace element deficiency, but not impossible.
if you've been engaging in bad irrigation habits, that can definitely be a cause of various symptoms.
1) fully saturate - if in soilles, also religiously get 10% runoff or more -- never let it sit in its piss, either way.
2) wait for appropriate dryback and repeat.
while there is a little leeway in exactly how much you allow it to dryback between, these basic steps are the correct way to irrigate. if doing it wrong, fix it. you do not whimsically choose the volume of water to provide... you give what it takes to accomplish the first step and no less. if you allow the same dryback (loss of weight) then you can roughly predict the volume needed for the sake of any fertilizer mixing.