Yes, my clients really need & want a solution like this. Alternatively, simply the ability to INCREASE THE HEIGHT of the headers would be enough.
For now, our only real option is to use some abbreviation for our field names and then put a description of the field in the “field description” info window.
Did this ever get actioned? I totally agree it would be a worthwhile improvement but a quick search didn’t return any further information about this update.