Hey all!
Though I would post this here. I was using the solution provided by @SplinteredGlassSolutions until today when the HTML structure of the table component changed. This has happened a couple of times so I tried finding another solution based on property selectors. It is working well as of now and hopefully, it is a bit more permanent.
div[data-row-index="-1"]{
height:80px !important;
}
span[data-testid*="HeaderCellContents"]{
text-wrap: wrap !important;
}