You’re describing morale, not chemistry. Anthony Edwards’ morale would be affected by losing, not by low chemistry. Low chem just drops OVR ratings.
The best balance IMO would be to make Chemistry extremely important while making morale far less so, to avoid the situation you mentioned with rookies souring on their teams right away for losing.