Ditto, not necessary for most tanks, but it is good to have a battery-operated one on hand for emergencies. Someone on here lost power for several days, and they had a major fish loss. I think they were able to save one tank or something out of many. The main thing for O2 is to have good surface agitation. This is where most of the O2 exchange is completed, and air bubblers generally aren't very effective. You should get a diffuser which turns it into a large amount of very fine (very small) bubbles to increase the surface area of the bubbles which helps maximize their effectiveness.
That said, bubbles look pretty cool, and I used to have a bubble curtain until the wand got plugged up. Oh, and I use them to power my sponge filters.