Frehley’s family says their loving, caring words, and prayers surrounded the legendary Kiss guitarist in his last moments