
The great… in the sky
Emotional Tone
The phrase often carries a sentimental or respectful mood when referencing someone's passing. 
Euphemism
It's a softer way to talk about death without mentioning it explicitly. 
Idiomatic Context
Understand it's an idiom; don't take it as a literal description of heaven. 