It will still hurt Sony but not necessaraly in “home consoles”.
Most CoD tournaments have been played on playstation console for a long while now. It wouldn’t surprise me if Microsoft forces esport to use xbox which also mean that the pro players base will have to move to xbox too.