Text this: Non-perturbative effects of primordial curvature perturbations on the apparent value of a cosmological constant