"Bad" is what I used growing up. I think it's by analogy to food--you would say that food has "gone bad" after a while. Similarly with batteries. You might also ask "are these batteries (still) any good?" to question not their quality in general, but their state.
It's almost certainly a regional thing.
He managed avoid the "flat" vs. "dead" controversy by making up a new convention altogether.
I think "consumed" would be most appropriate.
I'd say "depleted" but we're all missing the point.