What about motor_vehicles? My preference is to not add a top level access=no but instead specify each mode, you've added bicycle=no, foot=yes, but it's now unclear about access by emergency services, given the gates here it's probably motor_vehicle=private ?