I was on a large RCI ship that ran into incredibly rough weather (it was during hurricane season). It was not that bad. Make sure you take Bonine every day if you are concerned about sea-sickness (buy it at CVS or Walgreens and not on the ship).
The captains of the ships are very experienced and know how to handle rough weather. To be honest, I actually still had quite a good time.;-)