I just booked a Star Wars Dat at Sea Cruise for next February. I might have a Disney/Star Wars problem.
My son (almost 8) BARELY made it to the fireworks (and is also not a huge fan of loud noises). We ended up sitting near the front, off to the side by one of the lower handicapped accessible tables (prepared to move if I had to). He actually fell asleep on half on the ground/half on my lap for awhile. If you look at the stage area, we were off to the left side (figuring most people would want to use the tables on the right side). From overhearing the CM's it seemed like they knew how many people had requested accessible seating and when it got close to the time of the fireworks and there was no one using those tables they removed the signs and actually encouraged kids to come forward to the front. Sitting at the front, on the ground, the view was AMAZING!! It really feels like the fireworks are RIGHT THERE on top of you!!
My son said they were the most awesome fireworks he's ever seen (high praise as most things are just "eh, okay").