You're correct on both points.

Some early wireless cards used SDIO to communicate with the host computer. These are long gone.

There were also some later SD cards which contained an embedded controller running Linux, which emulated an SD storage card and exposed its contents over wireless. The latter are what that article was about.