The idea of a "batería muerta" sounds very funny for a Mexican; I don't know if there's any other region where this image would be natural though.
We're much more likely to say:
- la batería se descargó
- una batería descargada
Edit: For a car we use "batería" in all cases, never "pila".