motor_vehicle=yes means the public can drive their car through there, if there's a locked gate then it would be motor_vehicle=private.

Imagery isn't clear but there looks like there may be a gate near Acacia Road.