I've always assumed it's a kind-of safety net for people who don't want to take ultimate responsibility for their own decisions, or something.

Believing in a higher power maybe gives them comfort that other things will get taken care of. Kinda like when you hire a cleaner and you don't have to worry about having a dirty house anymore. Relieving some pressure on your brain, or something. Appealing for some I guess!