Why only 6 water molecules are formed in the aerobic degradation of glucose?
Your confusion comes entirely from this equation:

$\ce{C6H12O6 + 6O2 -&gt; 6CO2 + 6H2O}$

This reaction is the combustion of glucose. This is not how glucose is oxidized in cells! Why so many biology texts and courses present this equation when introducing metabolism is beyond me.

Indeed, your tracking of water molecules is correct: starting with one glucose molecule, 2 waters are produced in glycolysis, 4 are consumed in the tricarboxylic acid cycle and 12 are produced during oxidation of NADH/QH2 (ie FADH2). This gives a net total of 10 produced.

Why is this different from the combustion of glucose? The answer lies in the oxygens introduced by inorganic phosphate during substrate level phosphorylation. Consider the balanced net reaction for the biological oxidation of glucose (simplified by ignoring ATP produced by oxidative phosphorylation and substituting ADP/ATP for GDP/GTP):

$\ce{C6H12O6 + 6O2 + 4ADP + 4P_i + 4H+ -&gt; 6CO2 + 4ATP + 10H2O}$

In particular, consider the formation of ATP from ADP and Pi (HPO42-). In both substrate level phosphorylation reactions (catalyzed by GADPH/PGK in glycolysis and succinate-CoA ligase in the tricarboxylic acid cycle), inorganic phosphate nucleophilically attacks the activated carbonyl (thioester) of the substrate and is then transferred to ADP (to form ATP):



The oxygens of the original inorganic phosphate are coloured red. The key point is that an oxygen atom from HPO42- is transferred to the substrate. This oxygen is later removed in the form of carbon dioxide, via oxidative decarboxylation, during the conversion of pyruvate to acetyl-CoA and in the tricarboxylic acid cycle. This occurs four times for each glucose molecule entering glycolysis and is accompanied by the reduction of NAD+ to NADH. Given that NADH is used to reduce molecular oxygen during the electron transport chain:

$\ce{NADH + H+ + 1/2O2 -&gt; NAD+ + H2O}$

...this explains where the four, apparently extra, water molecules come from when comparing the combustion of glucose with its biological oxidation.