Freescale (formerly Motorola) transducer elements like the MPX5700GP (as well as those pressure elements available from others like Fujikura, MSI, etc.) are fine as long as they are used in air. If you look at the datasheet for the MPX5700, you will notice they specifically state "dry air". If you are measuring water, and position the pressure tube such that there is air in front of the transducer, you will have a design that works fine for a few months to a year or two before it fails (been there, done that!-don't repeat my hard-earned lesson!). A sensor element exposed to air in front of water sees moist air, and the sensor element will fail given time. Diaphrams used to isolate only result in hysterisis and offset. Silicon oils injected to cover the element will cause a smaller amount of hysterisis and offset, and only delay slightly the failure from moisture.
Since you posted in an automotive forum, I suggested an automotive grade transducer. There are other manufacturers who make transducers similar in appearance to the Sensata, who also serve the vehicle market (such as Kavlico suggested by sreid). The problem with low volumes is sometimes finding a part that is standard enough that it's available at low volume. Many of the companies servicing vehicles and automotive world only sell in high volume with only a few offerings available otherwise.