There are three main mechanisms of colorblindness, corresponding to the three main types of light receptors in the eye: deutan (green-weak), protan (red-weak), and tritan (“blue-weak”, although this is not a common term). About three quarters of color vision issues are deutan, one quarter is protan, less than 1% is tritan.
When you go out into the world and start interacting with contrasting color pairs, both green-weak and red-weak color vision cashes out as “red-green colorblindness”, while blue-weak cashes out as “blue-green colorblindness”. None of these have issues distinguishing yellow/orange from blue.
Presumably this is actually the motivation for the international air safety color being orange, as it’s easily distinguishable from blue sky.
Keep in mind that I can judge saturation and brightness just fine, and that's a big part of what makes that shade of orange stand out.
I'm not always aware that there is a colour I have not correctly perceived, and may simply think that a colour is 'brown', where others clearly perceive it as red or green. However, it's very rare that this causes me problems. I suppose electrical work in low light might be risky, but then I would be taking extra steps to ensure I did not screw up (increasing lighting, asking someone to double check before I touch anything, etc.).