I would also like to see water magic but there's a lore reason RDM doesn't have any. During the War of the Magi the Amdapori white mages only fought with earth and wind magic against the Mhachi black mages' fire, lightning, and ice magics. The extensive use of those five elements heavily tilted the land's aether away from everything but water, which allowed the Ascians to rejoin a shard via flood. Red mage arts are descended from the Amdapori and Mhachi survivors of the flood, and those white mages didn't use water.
I'm not bringing that up to say that it's writ in stone that RDM can't have water magic--I'm a quick study combat genius who could invent a Verwater spell if I wanted, obviously--but just to say there's a flavour reason for the current lack of water spells in the Eorzean jobs.