i have been attending this church where i joined under watch care and now i am a member of the choir. There are people that are tone deaf and the director is aware of it but doesn't really want to affend them. what do you think should be done.
Without helping folks fing their "true" ministry, one was to alleviate this situation would be to put these "weak" singers between strong singers to help them hear their part. I have a friend who isn't a very good singer (praise God that he recognizes this fact), however when he and I are singing in the congregation together, he can hold his pitch by listening to me.
So, to me that's the best way. Other than that, your director might want to suggest another fine arts ministry. Are they good at poetry or dancing, etc? I believe some people join the chior "just cause" and it's up to those in leadership to direct God's people to their true calling.