I actually like to imagine no matter in what state the water is when it collides (considering an asteroid-size mass) it would evaporate on contact creating a superheated steam that would expand along with the liquid bedrock splattering from the impact and a huge dust cloud. I don't think that there'd be any significant tsunami though.