That seems like a common problem with Sony 128gb 4k sd cards. That happened to me one month ago in the middle of my Venice trip. I sent it directly to Sony service when I came back home. They managed to recover the photos and sent me a new card which I will never ever use again
Just to put this in perspective, we've used cards from a number of vendors here, including Sony, and over quite a few years, the Sony cards have been the most reliable brand (in fact the only brand we've yet to experience a failure on).
Clearly you were unlucky. Good that Sony were able to recover the contents for you, and it's a pity if the experience has led you to conclude that other manufacturer's cards will be a better bet. Based on our experience to date, I doubt that will prove to be the case.