I believe the amount of water used for lawns is an order of magnitude smaller than the water used for fracking. The water for fracking is definitely lost, while the water we use even for bathing is recycled infinitely.
I will say, though, that in North Dakota, they get a significant amount of their fracking water from Lake Sakakawea, i.e. Missouri River. The amount of water used for fracking is a rounding error compared to how big that lake is. Might be more of a concern in more arid areas, though.
As far as "recycled infinitely", that may be true, but out here in the West that is a yearly timeline. We get most of our water from the melting snowpack. Once we use it, it is gone until it snows again next winter, and melts again next spring.
However, industrial uses of water definitely outpace consumer usage.