Am I right in assuming that this detection method will only work when there is a distinct boundary condition - ie a layer of water or ice with a layer of fuel on top - as opposed to the situation where the tank just contains a mixed fluid?
Yes it detects the boundary. The transmitter is very low in the tank so it is usually immersed in fuel, and the beam goes down to the bottom surface and back.