In the SPI mode of SD card communication, the pin CD/DAT3 is Chip Select. So the Card Detect functionality is not valid in this case.
MAX13035E
Recommended for New Designs
The MAX13030E–MAX13035E 6-channel, bidirectional
level translators provide the level shifting necessary for
100Mbps data transfer in multivoltage systems...
Datasheet
MAX13035E on Analog.com
In the SPI mode of SD card communication, the pin CD/DAT3 is Chip Select. So the Card Detect functionality is not valid in this case.