Have you tried a smaller card? 32GB was pretty well unheard of, even in the DOS 6.22 days.
It’s been a very long time since I’ve thought about stuff like this. It reminds me of when I was trying to get a 1GB drive working on a 486 when I was in college. The drive wasn’t seen (just like you’re seeing). What I had to do was install the manufacturer’s backwards compatibility software (it was for systems that were too old to have BIOSes that recognized drives that big) so that the BIOS, when it probed the hard drive would somehow load a TSR that added support for large hard drives.
Looking up the card in question, it loads the XTIDE BIOS, and the card has “Select XT-CF(PIO) Mode/Base IO 300h” silkscreened on the back. Zooming in on the front of the card, it doesn’t look like you can set that on the DIP switch block for some reason. I don’t see any documentation for download from the site. Did any docs come with the card?