No, it won't drop you drone into the water, but it will limit your altitude. It's another DJI invention: Altitude Zones: Altitude zones will appear in gray on the map. Users receive warnings in DJI GO, or DJI GO 4 and flight altitude is limited.
Check TFRs before you fly there, though. It does fall within the NFZ for Giants games.