One workaround that might help you for the time being is to select the cell you’re interested in, then press Shift+Spacebar to open an expanded cell dialog. Then you can use arrow up/down keys to switch which row is selected and see all the text in the cell for that row.
The lack of wrapping text is an intentional design decision: to allow wrapping text, we would need to support variable row heights. Our rows are a consistent height in order to avoid the bloated mega-rows that you often find in spreadsheets. Generally, we believe that that table/grid view should be a good overview of a number of different records, whereas the expanded record view gives you the details.
Based on the amount of user feedback on this point, we may offer the ability to change the row height at some point. Alternatively, we might look into a non-grid view that shows each record as a card rather than a row, and this “card view” might support multiline text in a way that would enable you to fit more text information on a single card without having to expand it.
Out of curiosity, how would wrapping text fit into your personal workflow? Do you like to scroll down the table row by row in order to view the content? How many lines of text do you need to be visible—just a couple of lines, whole paragraphs, or multiple paragraphs? Do you need to scan through/read multiple cells at a time, or do you just need to quickly find an appropriate cell of interest and read it, without going to the trouble of expanding it?