I have one of those SanDisk adapters as well. I found it does not work with a random USB-C cable end so I suspect SanDisk has some sort of “polarity” on their included cable. Please note, I have not done any engineering analysis of their cable.
I feel it important to highlight the recent catastrophic issues SanDisk external SSDs have experienced. Having read a number of articles on this, it appears to be on devices manufactured since November 2022, but that could change over time. SanDisk was mostly silent on this, released a firmware update that did NOT fix the problem, and instead seemed to focus on slashing prices to move units quickly. Ethics at Western Digital seem to have once again become an inconvenience.