I have had multiple failures of SD cards (Lexar and SansDisk), only one of which I was using as internal storage.
I can actually throw an SD card much further than I can trust one.
When they fail, it is usually without warning- and EVERYTHING on the card is lost forever.
Then when you attempt to use it again, you will be asked to format it again.
(Anything on it will be erased.)
You may do so, and it may work afterwards.
Do you trust it after that?
No.
The answer is no.
Professional photographers that use these things in their line of work are the ones to ask about SD cards.
They lose big money if a card crashes with a customer's content on it.
(Think about wedding photographers and such.)
I found this during a time limited search on SD card failure rates.
Although this is from 2017, I can't see much improvement being possible- since my issues all occured from this timeframe onward.
Most recent for me was the complete failure of a 256GB card that had about 30GB on it and was about a month old.
This happened about a year ago, and since then I have refused to invest time, effort, or money in large capacity cards.