https://maps.app.goo.gl/F1q4wYNRdCBzK6XK8

The sign says only vehicles with permission are allowed.
I recommend setting:
vehicle=private
on the whole road on the bridge and where the road ends on the island, delete access=no and not adding any other tags for foot/bicycle/horse