As someone who was unable to sleep for several nights at one of the All Stars (Music), I'd like to say that this had nothing to do with cheerleaders or people in the pool or crowds.
It was because the walls at the All Stars, and, from what I've read, at all the WDW Value resorts, are paper-thin. We heard everything from the room next door--conversations, baby crying, conjugal activities, etc.--as well as every single luggage cart that rolled by our room, conversations by passersby in the corridor, and noise from the stairwell (we were near the end of a hall). That doesn't even take into consideration the turboflush toilets, which are in most (all?) rooms at WDW, but the noise there is easily mitigated by closing one's bathroom door.
I've lived in an apartment (not the same one!) all of my adult life--not in a house in some secluded, quiet area--so I'm very used to a certain amount of noise from traffic outside and neighbors upstairs, downstairs, next door, and in the hallways. But this was far beyond that. I was unable to sleep, and I wouldn't really describe myself as all that sensitive to sound at night.
If your wife is sensitive to sound while sleeping, you might want to consider either a Mod or a Deluxe resort. Even if the location of the room at the All Stars made a difference--and I doubt it does, since all the rooms are built with the same materials--you wouldn't be able to get a guaranteed location when you booked.
The WDW Value resorts are very cute and the food courts are great, as is the transportation, but in-room noise is another issue. Please consider it carefully before you book.
Hope this helps.