Do the flanges create a water tight seal around the pipe and hole that the pipe passes through?
No. The flanges are strictly cosmetic. If the penetration in the finished surface needs to be watertight, you will need to use an approved silicone product for application.