You seem very experienced at wine and food, so I hope you know this. I can taste a wine and like it just fine if I haven’t eaten or drink anything else. But if I eat anything, even just the tiniest bit, the wine to me just becomes sour and I can only taste the alcohol. This completely ruined wine for me. Is this common?
The phenomenon of one flavour "colouring" another is perfectly normal. So that in that sense it is "common." I've not heard too many people say that food will "ruin" wine for them, though.
Wine "pairing" is a whole thing. Certain wines go better with certain foods. A good sommelier is expected to be an expert in wine pairings and will recommend wines based on your food order.
The principle is what chefs think of as "balancing" flavours. There are 5 recognized basic flavours: salt, sweet, acidity (sourness), bitterness and "umami" (savoury).
When learning to cook creatively aspiring chefs will think about balancing these flavours, as each will affect your perception of the other. Salt will "neutralize" / "tame" bitterness, sweetness will do the same for acidity / sourness and vice versa.
If what you find is that your wines taste sour after eating a food, then you are probably sensitive to sweetness and / or sourness. Most people can experience what you are describing by eating a bite of something really sweet, like cheesecake, and then tasting a dry wine. It will taste VERY sour as a result because your taste buds have just been desensitized to sweetness based on the really sweet food that you just ate, so the sweetness in the wine will not be perceived, leaving only the acidity.
It just sounds like in your case this phenomenon has been dialed up to 11.
Some people have hypersensitivity to some particular taste. I'm oversensitive to bitterness, and basically can't drink beer at all, and only the sweetest wines (late harvest, icewine and similar) are actually enjoyable.