Excess nitrate in drinking water is converted into nitrite in the human body.
Nitrite reduces the oxygen-carrying capacity of blood, leading to methemoglobinemia (``blue baby syndrome''), especially in infants.
Hence,
\[
\boxed{\text{Methemoglobinemia}}
\]
is the correct answer.
Therefore,
\[
\boxed{(D)}
\]