I am trying to understand the intuition behind Exclusive or.
Why it is called exclusive or? Wikipedia says: it gains the name "exclusive or" because the meaning of "or" is ambiguous when both operands are true
Wait! why "or" is ambiguous when both operands are true? Or says nothing about ambiguation.
"Or" is ambiguous in daily life. Some times when people say "or", the option of both is not considered a valid option ("Will you take the red pill or the blue pill?"). Some times it is ("Did you go to some fancy school, or are you just smart?"). You have to tell from the context, which means that the word itself has both meanings and is logically ambiguous.
In the field of logic, "or" has one and only one meaning, and that is that the option of both at the same time is considered valid. However, some times you need to express the idea of "either-or", where choosing one option excludes the other. Where the case of going with both is excluded. That is what exclusive or is for.