There is a very informative video[1] that also links to scientific papers about this phenomenon and concludes much less sensationally.
Essentially, urine is a sterile substance containing %95 pure water and no living cells or bacteria. Other than the asthma inducing effects of chloramine, swimming at a public pool doesn't pose a massive threat to your health.