House rule it and try it. Who cares what other people think? Maybe you'll love it. If it's a good idea, it'll catch on.
I couldn't care less what other people think but it's sad to see people so closed minded.
My initial reservation is that it potentially creates an issue where every time they run into serious trouble, players start having their characters pray to the gods. It could get silly very quickly.
Depends how it's implemented. If all it does is stabalize a PC, then it's mostly flavor.
If it can accomplish something more serious (actually Grant HP, for example)? Attach some costs that are interesting, flavorful and most importantly consequential.
As important as they're supposed to be, Gods have very little actual impact in most campaigns. If there is some interest in changing that - stuff like this might be a way.