You are in the middle of the ship so you won't feel as much motion. Also it is one of the lower decks so you won't have as much motion.
Carnival Dream for Thanksgiving
Eastern Caribbean- 11/20/2010
Carnival Ecstasy (4 Day Baja Mexico) 2003
Carnival Pride (7 Day Mexican Riviera) 2007
Carnival Spirit (8 Day Exotic Mexican Riviera) 2007
Carnival Freedom (7 Day Western Caribbean) 2008
Carnival Elation (4 Day Baja Mexico) 2009
Carnival Spirit (7 Day Southbound Alaska) 2009
If you get motion sickness easily you may want to rethink this trip. Although you have a great cabin, any kind of rough seas will affect you. The oceans dont care if you are in first class or steerage, it will get you if it wants. Take plenty of meds leading up to your trip and on the ship as well. Hope the weather holds out for you...
2008-Valor and Glory
2009-Spirit and Splendor
2010-Freedom of the Seas and Mariner of the Seas
2012-Allure of the Seas and Navigator of the Seas