There is an issue of Royal Canin Veterinary Focus that focuses on lower urinary tract disease in cats and dogs: https://vetfocus.royalcanin.com/en/-/media/vet-focus/en-us-p...
There are interesting sections on Feline Idiopathic Cystitis and blockage, which talk about water management as well. On page 23, there is a table called "Table 1. Clinical features of cats diagnosed with cystitis with (n = 8,220) or without (7,862) concurrent pyuria in 2012."
At the bottom of the table are a few rows on diet. ~3.5% of cats in the sample were on a canned-only diet. ~19.2% were on a mix of dry and canned food. 77.3% were on a dry-only diet (percentages slightly varied for those with pyuria).
When I hear other cat owners feeding only dry I tell them this. They don’t usually want to change, likely believing that wouldnt happen to their cat, but at least they’re informed.