Will expanding foam Fix a water leaking problem?

Foam is not designed to stop leaks. Its designed to fill spaces to prevent air movement and vermin incursions.