One should not assume there will never be an issue. I have been using XQD cards since 2016. I generally use Lexar XQD cards in my D500 and D850, bought before Lexar exited that market. I have used Sony XQD cards in a Z6 and Z7. Now using Sandisk CFe cards in my Z7II and Z6II.
I may be an unlucky person, but I have had two issues with Lexar XQD cards since 2016. The first incident was on a 2017 trip to Galapagos. I needed a dongle to use my Lexar XQD reader with my MacBook Pro (which has USB-C ports). No error messages from the camera while shooting. When I went to transfer my images from the XQD card to the laptop, around 100 images from the card did not load. When I looked at the card with my laptop and reader, they were not there (the other images — several hundred — were). I also had the images on a high speed Sandisk Extreme SD card (300 mb/s), as I was using my D500 and had a card in both slots (understand that the second slot can slow the camera down), so I loaded the missing images from that card. Thom Hogan was leading the trip and he thought the issue was likely in the reader/dongle, and recommended I not use it anymore. Since I had the images on the SD card, we did not try any rescue software. After that, I used both an XQD card and an SD card, but loaded the images from the SD Card (my SD reader did not need a dongle) and kept the XQD versions as backups. I disposed of the XQD card where I had the issue, in case it was a card issue. I also disposed of the Lexar reader when I got home and got a new Sony one with a USB-C cable so that I did not need a dongle.
My second incident involved shooting at a local wildlife refuge in 2018, watching a group of migrating great egrets fish, fly and land. This time I got an error message from my D500 (don’t remember the exact wording, but said something about the camera not seeing the XQD card). It was also a Lexar XQD card. Again, I had a fast Sandisk SD card in the second slot. I took the XQD card out and kept shooting with the SD card. When I got home, I loaded the images from the SD card. But I also tried rescue software on the XQD card and was able to get most, possibly even all, the images off that card (I had not taken precise notes about exactly how many frames I had shot when I had the issue). Disposed of that card too. I have had no issues subsequently with XQD cards in my D500 (whether Lexar or Sony), so I think this was the card, not the camera.
Overall, I’m not an expert or an engineer, but I score this as likely one reader/dongle failure and one card failure. And possibly no lost images, given rescue software (although we did not try that in Galapagos).
I have had no issues with my Sony XQD cards or my more recently purchased Sandisk Extreme Pro CFe cards. Around 125,000 images on my Lexar XQD cards; 60,000 images on my Sony XQD cards; and 50,000 images on my Sandisk CFe cards.
Although I have had a couple of issues, I do not generally put an SD card in the second slot unless I am photographing a one-time only event (for example, my mother’s recent 85th birthday party).