While you can revive dead merchant NPCs Celestial Dew and atonement at the Chuch of Vows, Varre is an exception. He is permanently dead even at the church of vows, he cannot respawn.