Yeah, it also assume that the pile you're driving can be arbitrarily long and will last forever. They used to be made with trees, for which this is obviously false.
I suspect, but don't have data on, that wooden piles may actually last longer in those exact circumstances due to galvanic issues with concrete and rebar or metal pilings.
Parts of Amsterdam as well.
When building fences, the ground-air interface is often where rot occurs, and there are products to protect that area:
* https://www.postsaver.com/en-gb/products/pro-sleeve-fence-po...
Stones could help with drainage and drying as well.