Yes we sailed (and then 2 more since then)!
Temperatures were shorts weather once we got to Bermuda. The water was chilly, but I got in because the little coves were so lovely I had to swim for just a bit. We had a lot of rain, so that cooled temps off a bit. I feel like October could go either way in terms of being truly beach weather or just "it's nice out weather".
We have sailed 30
DCL cruises and this was the roughest I've ever felt (second worst was also on the Magic in the North Atlantic skirting a hurricane). It was pretty smooth on the way down, the way back to NY was insanely rough. We had so much wind, there really wasn't much the Captain could do. We still had a great cruise. I don't know that I would sail to Bermuda quite that late in the season in the future.