Welcome to the forums

Most wireless cards require either Windows drivers - using a tool called ndiswrapper - or binary firmware.
Because SME Server is designed for servers, wireless NICs aren't really supported. However, Red Hat, our upstream provider via CentOS, does support wireless more generally, which is why the hardware may be detected and may in some cases even work.
FWIW, your card appears to use the native Atheros driver, if you wanted to experiment with CentOS 4 packages for this chipset.
Anyway, the way I usually handle wireless access is as follows:
In test environments, I use VMWare and create a NAT connection so SME can piggyback on the host's wireless adaptor without having to load a WLAN NIC driver.
In production scenarios, I set up a Netgear 614 wireless router as an Access Point on the LAN side of the SME Server. The 614 can act as an AP only with all routing functions disabled. It supports DHCP passthrough, so wireless clients can obtain DHCP addresses from SME Server in the same way that wired clients can.