Do they really turn sewer water into fresh drinking water?

Yes, they really do.

Even if cities didn't do it, the clouds and atmosphere would. Water is constantly recycled. It is also being assembled and taken apart through certain processes. On the bright side, you have probably ingested a water molecule that one of the great Cesars also processed.