The consensus is that the concept of five colours of mana is only really understood by a select few groups. This includes Ravnica (though most recent flavour implies that they're unaware for some reason), the Jeskai monks (no word if the Ojutai have this knowledge), some people on Dominaria including the ones Feldon met, and Alara (both before and especially after the Conflux).
Most planes at most recognize different types of magic, like pyromancy and hieromancy. Most people have not dwelt deep enough to see the colour pie.
Right, I thought as much, but the few that do, do they understand the basics we do? (ex: you're a "red-aligned" Goblin Rogue / you're a "blue-aligned" Merfolk Soldier) and if so, where's the affiliation come from?
I think the point where a mage would become somewhat aware of colour-alignment is when he tries to summon people. Provided you have a basic understanding of different colours, you'd probably notice that summoning your average goblin just doesn't work without
or that merpeople generally require
. The same is true for animals from different habitats. On the other hand, a red mage who lives in the mountains, only has access to red mana and mostly just encounters people and creatures who also live in the mountains might never figure that out and just go with using red mana forever without any difficulties. He could just summon pretty much every barbarian, ogre, goblin, dwarf, cougar or mountain goat he has seen.
Which brings us to the causes of colour affiliation, and as far as we know, the environment you live in does play a role. That's also explicitly confirmed in
Legends II for instance. The same trilogy also states that the spells you frequently use influence what colour you are, and so does your race if it's something colour specific like elf. For instance,
Marhault Elsdragon is stated to be
because his army base is in the mountains and because he often uses red mana from those mountains; he's also green because he's a half-elf and his elven heritage pushes him towards green (he uses some green elven magic, too). That all neatly lines up with what we see on the cards, too. And more often than not, those factors go hand in hand, because living in the forest not only makes you more likely to be green to begin with, it also means you'll probably use green mana if you're a spellcaster, so you being green-aligned becomes a self-sustaining loop of sorts. If you're also an elf, you probably have a natural affinity for both using green mana and living in a forest anyway.
Devoted Hero or
Keen-Eyed Archers might be white elves because they grew up in a white environment and with white values, perhaps with a typical white military background. They might have undergone a change from
to
later in life, too, like Kamahl did from
to
. In Kamahl's case, a change of perspective or personal philosophy was involved, but he also started hanging out in a forest and using green mana, so it's probably a bit of a hen-or-egg situation. The way colour affiliation and environment are portrayed in Magic, there's also often a correlation between people's personality and the environment they live in. Living on a
aligned farm might go hand in hand with valuing community and co-operation among 'the little people', having to survive in a rough swamp society (e.g. Takenuma swamp) might make people more ruthless and fuel ambition to get out of there and have a better life. That's a super simplistic way of looking at it and by no means the main cause of colour alignment, but I feel it's sometimes portrayed like that, even if it might be flimsy.