I don't think it altered much of anything. I don't think most people cared or gave any thought to it. I doubt it changed even the space fans. This sounds like wishful thinking from a group looking for an easy way to alter intractable human nature.
I hope it makes you reconsider your position about disregarding non-quantifiable benefits.
> But when the McNamara discipline is applied too literally, the first step is to measure whatever can be easily measured. The second step is to disregard that which can't easily be measured or given a quantitative value. The third step is to presume that what can't be measured easily really isn't important. The fo[u]rth step is to say that what can't be easily measured really doesn't exist. This is suicide. — Daniel Yankelovich, "Interpreting the New Life Styles", Sales Management (1971)
The "Overview Effect" thing also struck me as self-serving bullshit. It didn't seem to reflect anything I ever saw in the real world. It was something a space fan would like to be true, and so motivated reasoning took hold.