I actually used to think that ice should be weak to water. Fire melts it more faster anyway, so I think it kinda makes sense on why ice would be neutral to water while it's weak to fire. I used to think that bug should be weak to water as well. Same concept.
Yeah, it's a good middle ground. However, the more I think about it, Water-types do have good coverage against Grass and Dragon with the Ice-type attacks they have at their disposal, leaving only their own type as an actual resistance. I guess Ice could help alleviate this problem should it resist Water. I'm on board now lol