When we did concierge, we did not have a room with a fireworks view. We could, however, go to the lounge to watch them.
Keep in mind that the lounge is not a DTD overlook - it's over the North Wind (monorail) Courtyard. It's just higher than all of the rooms on the DTD wing, so you can see over them.