I was seriously concerned about getting sick when we first looked at cruising. I get/got motion sickness in a car unless I was driving, and don't even think about getting me on a carnival ride :-)
But based on information I received on Cruise Critics we took our first cruise (Canada/New England) and I took Dramamine (non-drowsy) pills. We took one the day we were leaving, and one the following day, and then stopped - I never felt sick. We have now done 5 cruises, and the Dramamine has worked fine. On our cruise last year (14 days through the Panama Canal) I also got a bottle of Ginger capsules - just in case - but never needed them.
We have only been on larger ships (all Princess) and they have good stabilizers so you rarely feel any motion. But after he second cruise we actually started looking forward to the motion at night (when you're normally out to sea) - it made for great sleeping :-)
The Alaska cruise we did out of Seattle (inside passage) and only once felt any motion - the first day when they go out more and go faster to get to the first port. But I never got queasy.
I hope you decide to go - and hope you find something that works well for you!