What you mean is nocturnal animals can see in low light INTENSITIES not that they see low ENERGY photons. The energy of the photons from those distant stars has not decreased, the number of photons has decrease by 1/r^2.
This may or may not happen. The ambient light is from stars in the milky way. The milky way is not expanding due to the expansion of the universe. The gravity of the milky way is overcoming the expansion. So in all likelyhood the ambient light will not fade untill all the stars in the milky way die. However, if the acceleration of the expansion continues it may go to the point of tearing apart the milky way or even tearing apart all matter.
This is the problem with not having an education in science you do not use the correct terms. What you mean is that the intensity of light deceases with distance. Specifically the intensity decreases by the square of the distance.
No one has disputed that light must be in the visual range to see.