I've never quite understood the entire "temperature of light" either. Or why it only applies to light used for... lighting. Or why the standard reference is some unobtainable black body ideal. Never could quite figure out why they didn't use some sort of positional depiction on a spectrum.
Well
1. Well, it's a standard used for light emission? Colored LEDs and such are rated the same way, just for 1 wavelength, not simply the maximum
2. Black body is actually fairly obtainable. They're called incandescent lights.
3. It is a positional depiction on a spectrum, of temperature. Basically, the maximum temperature wavelength the emitter puts out.
4. We have multiple measurements. For example, the CRI(Color Rating Index) attempts to say how "white" the white light actually is.
Plus, everybody has different tolerances. If the light looks too blue for you, buy a "warmer" light. If it's too yellow/orange, buy a "cooler" one. Yes, the actual temperatures are flipped because humanity learned to associate fires with heat, which are actually cooler than the sun.
If it just looks funky, look for a higher CRI.