The “No Entry” sign does not apply to pedestrians, who are permitted to use this crossing. I don't know the exact history of the area, but it appears to be a bridge that was historically open to everyone, which has since been restricted to force cars to use roads designated for them. This helps prevent traffic jams in this area.
I think:
motor_vehicle=agricultural & bicycle=designated is better here as describe in the wiki.