It all depends on how much momentum change is required to detonate the missile.
A high pressure column of water directly in the path of an incoming missile might present a serious obstacle. Even one water hose might be enough. I think it's a good idea.