Newport, RI Weather?

Hi y’all!

I am seriously considering a venue on the water in Newport, RI for late September, 2025.

I have had conflicting opinions on whether or not it will be too windy or cold.

I know with being on the water it’s likely to be windier, but I definitely don’t want it to be miserable or mess up pictures with blowing hair and all!

Do yall have any experience or live in that area and could offer any insight? I’m from the south so I have no idea.

Thank you so much!