A lot of ROG boards seem to have this issue with the way the heatsink for DIMM.2 and SO-DIMM.2 daughterboards are designed.
You have single-sided and double-sided M.2s with different layouts and controllers with differing Z-heights, so incompatibilities are inevitable. It happens more often than you think even on motherboard M.2 slots - motherboard M.2 heatsinks are so big that it's hard to see the drive underneath at all, let alone whether it's bowed. Longevity-wise it's probably not the greatest idea but I suspect there's tons of slightly bent drives out there doing just fine.
Many boards include a set of black, square small rubber pads in the box. Usually they intend for you to install them on the PCB underneath the drive to buttress the drive and prevent it from bowing, if the situation calls for it. There's so much stuff with the R6E I can't tell if they include that for you, but it seems like DIMM.2 and SO-DIMM.2 boards usually provide it. The pad may make it worse or better, it's up to you to try.
Asus crosshair viii impact rubber pads? : sffpc (reddit.com)
Otherwise, the only other way is to back off on the screws a little. Works like a charm on one of my boards with a poorly designed heatsink (ASRock B550M-ITX/ac), where screwing it down all the way bends the drive like a banana.