I’m not seeing any pictures so either the forum is messing up or you forgot to add them.
That said, here is a link to an example of how to fade a material as it get’s nearer to a camera. My guess is that there is a “1-x” node somewhere that is inverting the effect.