here's some science that backs it up from
a random paper i found online:
"Water is very slightly blue in color as overtone and combination vibrational absorption bands extend through the red part of the visible spectrum ... This absorption spectrum of water (red light absorbs 100 times more than blue light), together with the five-times greater scattering of blue light over red light, contributes to the blue color of lake, river and ocean waters."
so based on that i think we can conclude that the less blue you have in the light source, the less glare you'll get off of water.
there also seems to be a lot of anecdotal evidence of cool white LEDs creating a lot of glare in fog, rain, and especially snow compared to warm LEDs and incans.
most of my experience is based on watering my yard and washing my car at night using at first cool white headlamps and more recently neutral tint headlamps. i much, much prefer using warmer tints when there's water spraying around because of the reduced glare. same applies to night hiking near moving water and waterfalls.