There are also 2 FREE Town moorings inside the breakwater in SD's picture but I'm not sure about the availibilty or even if they pull them and when they would replace them

As SD mentioned anchoring is a possibilityj there also.
There is also a little cove that I used to anchor in before I moved down to Wickford just a little ways south (maybe a mile) of Wickford. If you do try that cove you can pick your way in between the the rocks and the tiny little island or better/safer to head North of it and pull a U-Turn around that island into the cove.