The "Vanderpump Rules" star lost several family members in the last three years, and almost turned his back on the church as a result