The card is the major suspect.Get a better card like sandisk. for recorvery you may check https://www.aeroquartet.com I used them once and they are good especially with xdcam footage.
Good luck
Try photorec from https://www.cgsecurity.org/wiki/PhotoRec and if that does not work (though it will mostly on pc but you may have problem with audio) you then try https://www.aeroquartet.com thats’ your sure bet for xdcam camers but I can tell you it will be very expensive.
your best bet is to send your card to https://www.aeroquartet.com/ if you are windons or buy thier software if you are on mac but be warned that it will be very expensive!!! I was forced to use them once when I mistakenly formatted a card during shoot. More or less they are the only one that I know that can deliver on XDCAM camera codec.
Usually adobe cs4 master comes with the codec pack for xdcam ex but if you dont have that you may have to look into buy the codec from https://www.calibratedsoftware.com/