I've seen the fireworks from POP (actually it's Illuminations @ Epcot that you can see; the "big" fireworks show is at Magic Kingdom which actually can also be seen from POP, but those are REALLY far away). It's kind of neat, and definitely a magical touch (Illuminations is every night at 9PM), but it's a bit far away. It's definitely not like @ DLR and seeing the MK fireworks from a DL hotel, for example. The thing about WDW is it's so much more spread out. Everything tends to be far away from most everything else. Also Illuminations doesn't rely on fireworks as much as the MK Wishes show does.
Here's a video I found showing the view of it from POP, this might give you a sense of what you could expect:
http://www.youtube.com/watch?v=ouEOhkF6arc
Here's another with Wishes @ MK and Illuminations @ Epcot going on at the same time:
http://www.youtube.com/watch?v=mUw7t9N50dE
Now, if you do want to get a room that you'll be able to see the fireworks from, just request Illuminations view and have them add that to your reservation. It's really no disadvantage in terms of walking distance from the buses and food court (which is another thing you might be interested in requesting, since you'll be additionally surprised by how far the walks are from some rooms to the buses