A key element here is that the battery likely died _because_ there was no service. When the car's cellular unit is scanning for service, it uses significantly more power than usual—quickly draining the battery.
when you leave your vehicle at a trail head for a few days you can disconnect the battery leads, and greatly increase your chance of coming back to a live battery.