The light red usually appeared somewhat orangy/peachy, it's generally used as flesh for ansi artworks.

ex: https://16colo.rs/pack/ice-200207a/ti-war.ice

I think it was just determined that brown would be more useful than the darker yellow in practice. Other xterm colors are also a bit off from CGA/EGA/VGA DOS colors.