Dark photons and supernovae: Lessons from astrophysics