What product of cellular respiration creates an acid when in solution with water?
Cellular respiration itself, defined as the activity of the respiratory chain complexes I -- V (including ATP synthase), is not acidifying. On the contrary, free protons are captured during ATP synthesis, so cellular respiration acts to raise pH. But then ATP synthesis is always matched with ATP breakdown in reactions that utilize energy (muscle contraction, for example), and ATP breakdown liberates the captured protons again. So the complete cycle of ATP turnover is pH neutral. (For more information, see for examplle http://www.ncbi.nlm.nih.gov/pubmed/6298937)

The activity of the TCA cycle, on the other hand, produces CO$_2$ when oxidizing carbohydrates, and CO$_2$ dissolved in water is slightly acidic (pK$_a$ = 6.3) and so tends to lower pH. This is the main acidifying effect of oxidative metabolism. In animals, the CO$_2$ generated is of course released via the lungs, so the amount of CO$_2$ dissolved in body water is (more or less) constant, and therefore pH is stable.