Hi Mich, if you want a water-resistant device, you could try with a SAATI or GORE-TEX membrane. In my experience, I assembled a Gore GAW3381.43.0 vent (please check the first link below) in a gasket to protect a MEMS microphone from outer water and dust. This membrane is ok for acoustical purposes (AC variation of pressure around the atmospheric value), and should be ok also for pressure sensor ("DC" pressure variation) if the pressure variations are small compared with atmospheric pressure. Consider that this small membrane is already provided by a round-shaped tape for the application on the device.
However, in case you want to measure huge pressure variation or you intend a water-proof application, you should use LPS33HW (second link), which is designed for those purposes.
ref: https://www.gore.com/sites/g/files/ypyipe116/files/2017-10/GORE-Acoustic-Vents-Immersion-Application.pdf
https://www.st.com/resource/en/datasheet/lps33hw.pdf
