I have an AEM CAI on my 95 Accord and I've never had any troubles with water intake, ever.
The whole purpose behind a CAI to bring COLD AIR (or cooler air) into the engine. Imagine that?!
If you're just bringing air in off the top of the engine instead of further away, you really are not receiving the full benefits the system was intended for. Make sense?