My title was stated to make me feel good about my stateroom. Not feel bad about about having concerns as a mom.
As we all know DCL isn’t cheap. I could do Caribbean cheaper if it was just about that.
I believe that you have not understood my point.
All of the staterooms are nice overall. Some have a little more room, some have a verandah, some have a Murphy bed... But, they're all reasonably comfortable and quiet. When you book a cruise, you shouldn't be overly focused on the stateroom for anything beyond sleeping comfort as you will not be spending a lot of time in the room while you're awake.
We purposely booked a lower cost inside stateroom for an upcoming cruise because we were only adding it to the end of an already-planned trip as a bit of "bonus" time. This inside stateroom has no direct view of the ocean (our last one had a verandah) and is much smaller than the one we had previously as well. While we did enjoy sitting on the verandah at night for a little while, sometimes with a glass of wine, we spent 98% of our waking hours somewhere else on the ship. So, while a verandah or a direct view of the ocean (not a magic porthole) is "nice", what ultimately matters is being on the cruise enjoying all that it has to offer.
Many people believe that mid-ship and lower decks are best for reducing the chances of sea sickness. I can't give you a lot of useful feedback here because I haven't yet been on a cruise that has impacted me like this (and my December 2014 trip on the Dream was definitely in rougher seas and I was in 10624). If your concern is directly related to whether or not they're going to get seasick, no one here can truly help you in any way other than to recommend that you talk with their physician about the different medicines that might be available to them (Meclazine, Bonine, Scopolomine) and try them well BEFORE the cruise for each child to understand what side effects they might cause. Have them with you when you cruise "in case".
There is simply no way to know whether they are susceptible to motion sickness or whether a particular room will be any better or any worse for them. You'll have to sail with them to see what happens.