Although l reckon this will definitely flood at some stage, l do think it's a great design, and it looks fantastic. It's for crossing the defensive fortress in Halsteren (The Netherlands), and was designed by Ro Koster and Ad Kil. Because of the parting of the waters, it is known as the Moses bridge, and more pictures and information can be found here. Great stuff.
Saying that, although l really do like the look of it, never trust an architect (as my mother used to say). What is the point of designing something like this if it does end up flooding all the time. I'll have to check up on it in the future and maybe re-assess my verdict then. Time will tell.