Do SD cards contain CPUs? They need to if they do wear levelling.
But in any case I would not regard it as wise to use one (which does) for an industrial product which has to run for years. Using one for just storage is fine (SD cards will "always" be around, especially if you allow for micro-SD) but to rely on specific features is asking for trouble. I've seen this in avionics where various SD and CF cards have been used and all have become a nightmare. One company used a Sandisk 48MB CF card (in a product launched c. 1999) which had some special security feature (no idea what it was but it could prevent reading it in a normal CF reader, even at block level) and you can guess what happened. Now those cards are going for $ hundreds.
EEPROMs are not a solution; a device with 1M write endurance merely postpones the day or reckoning by 10x. In my project I have 512k, spread across 1024 512-byte pages, so wear levelling across that lot would enable the storage of 50GB of total data before it all wears out. A non wear levelled implementation with a single device, writing the 512 bytes over and over, would need a write endurance of 100M writes.
Yes, the SD cards do contains specialized MCUs, for the people in the know they may even get firmware SDKs to implement their own version of wear leveling, the evil ones are using these SDKs to change the size of the attached NAND flash and this how one can get a (fake) 128GB SD card for 4.99.
Normally the cards/EEPROMs for industrial use have internal wear leveling features and they cost a lot not because they're using some magic algorithms but because to have the specified reliability the NAND has to be 1) of good quality (SLC) and 2) grossly oversized to allow for transparent spreading of writes over a lot of cells.
For large amount of data and long time use, there are like a gadzillion of papers, doctoral thesis and patents, basically covering all the desperate attempts to make reliable a storage media that is inherently unreliable. One can choose all forms of error corrections, RAID configurations optimized for NAND, filesystems optimized for NAND and so on.
But no matter what you do, the flash memory is basically a consumable, and whatever industrial machine is there, if it has flash storage, it has a finite operating life and has to be replaced periodically, before it dies catastrophically, there is no silver bullet to solve this currently, but only to try to push the operating time (a bit) outside the warranty period.
Cheers,
DC1MC