I ran one game where a character’s situation got a little too close to a player’s situation. That particular player experienced a lot of bleed and really struggled with some stuff. It ended up causing the game to fall apart because it wasn’t handled particularly well (by myself and others).
It’s not weird or necessarily disruptive for players to have different amounts of emotional investment but if the discrepancy is too great it can cause dissonance.