I have a ton of experience with both light types since I use a combination of both.
Near-infrared light and red lights are awesome. From a scientific point of view, all light types have a role they play, but red and NIR light has more applications.
The difference between these two light types lie in their penetration distance. Red light penetrates deeper than most light types except near-infrared.
Red light helps with aging by helping with anti-inflammation and creating a good environment for collagen production, aiding a beautiful, healthy-looking skin. Near-infrared light has these effects as well, but capable of targeting deeper bodies and cells.