Guess this function has a way limited range (compared with some already existing proximity features of the ecosystems). At least some shore-foam can be emulated without using memory-eating waterterrain-objects.

Here one try:

The most important thing is that terrains have to be clipped because the 'distance to object below' node just projects the xy-shape of the "object below" onto the water/ground plane.