I wonder if the SD Express will be taken advantage of in the switch 2 homebrew scene which seems inevitable now.

SD Express is PCIe express after all (also a possible attack vector in itself, see DaMAgeCard). With nvidia drivers for Ampere already on board maybe someone will get an RTX 3090 running on a switch 2.