You mean that if neuroscience dispels the illusion of how we seem to be conscious, rational persons, science, too, will make no sense? Yes, I think I made that point towards the end.
But the main issue here is whether a special science such as psychology will only re-describe the folk image of the self, as opposed to explaining away that image. If you reductively explain X in terms of Y, that doesn't mean X no longer exists. It means X exists in virtue of Y. One thing is the result of another. Likewise, the mind might result from the brain. So neuroscience wouldn't necessarily eliminate the mind, by explaining it away as a dispensable trick of lower-level processes. The "illusion" of self-awareness would have some causal power, and the higher-level, folk-psychological description wouldn't be empty, but only low-informational or simplistic, compared with the neuroscientific explanation of the same behaviour.