It looks like you are right under the interior buffet so it shouldn't be bad. The carpet will cut down on some of the noise experienced in other locations ... like around the pools. Just in case though, pick up some ear plugs at the pharmacy before your trip. I'm a light sleeper too and find them very helpful.
NCL Sun, Oasis OTS, Navigator OTS, Legend, Fascination, Emerald, Glory, Mariner OTS x 2, Sovereign OTS, Celebration, Miracle x 2, Pride, Fantasy