If you don’t include housewrap, use a sill pan, and flash the flanges, the work is far from watertight.