The Buddha delves into this topic in more detail in MN 114.

Rancid urine was the worst of medicines, used when nothing better was available. Specifically, the Vinaya allows it as a purgative in the case of snakebite (Kd 6:14.6.4), and gives chebulic myrobalan soaked in cattle urine as a remedy for jaundice (Kd 6:14.7.9). Modern research has shown that urine, far from being a sterile cure-all, contains dangerous levels of bacterial pathogens, and has no medicinal value.

This text as well as MN 45:7.9 answer the question of what practice results in future happiness, and so do not consider awakening. It is surprising to see such bold praise for such a modest teaching. The Chinese parallels to these suttas have the inverse situation, as they describe a practice leading to non-return (MA 174 at T i 712b27) or Nibbana (MA 175 at T i 712c25, T 83 at T i 902c10), yet do not have this passage of praise.