the representative of a spray foam insulation contractor, RetroFoam of Michigan, tells us that, in fact, closed cell foam can stop water leaks in some cases, but that's not its primary function.