The lower decks are better if you're sensitive to motion. Think of the cruise ship as an inverted pyramid, with the point in the water and the broad part above. The point in the water gets very little motion, while the broad upper part swings back and forth. Same is true of a ship.
All passenger decks are above the water line.