It's just very difficult MecE design.
One company I worked for came up with a low cost solution, it was all unicorns and rainbows. They won many bids and deployed sensors- only to see them fail after a few months. The time-constant to failure is usually much longer with wet mechanical stuff compared to electrical. So they tried to fix and redeploy under warranty and repeat et. al that loop until all customers hate you and you're almost out of business.
Example: Sensor readings are bad, I opened up a surface junction box and found it was full of water. Turned out to be from capillary action of the wire that went down to the sensor. Wire makes great tubing I discovered, if you give it a few weeks.
The DP sensor versions a few got condensation drops in the vent hose, others a kink in the hose, plugging that vent. Some sensor ports got silt and sand plugging it, used sintered filter. All unexpected problems. The company tried filling the backsides with grease, silicone oil etc. in desperation it was kind of funny to watch people learn about engineering.
An absolute pressure sensor has barometric pressure to correct for if high accuracy is needed.
Best we got was a sub to enclose the sensor and the cable gland and we made our own. Even though a sensor is cheap, the finished solution sure adds up.
A commercial tape measure
Geokon/Solinst 101 sorta cheap cable USD $520. Note Geokon has no pressure spec for their cables.
There are also float and GWR methods if you just want to track smaller changes in level vs the 200ft absolute. It depends on what OP is monitoring water level for.