From the OSM wiki: "The access=no tag indicates that the object is not to be used by the public, with stronger interdiction than the access=private tag."  Your changes indicate that even the residents cannot enter here.
Also, this particular segments is marked as public on https://www.axisgis.com/CoventryRI/ (between lots 103 and 104.)  The same is shown on the official town maps: https://coventryri.gov/sites/coventryri.gov/files/attachments/Complete_set_0.pdf
Also, there are no signs on site that restrict access to Sunset Lake Circle.