We sailed from Southampton to NYC on a 9nt around 7 years around 24th Oct and the weather was really bad, it was extremely rough season too, nothing was open outside as the weather was too bad, I remember some shows and activities were cancelled too.
We've done transatlantic to the carribean many times but that's a lot further south and always had good weather after the first few days.