This says exactly what I said. Trash the CDs. Use the web-based configuration.
More discussion of the worthless CDs.
And even more discussion of the worthless CD software.
Long story short: Forget there is a thing called "Cisco Connect". Configure the router via the browser. Once your SSID, security mode, channel, and password are settled, 802.11n is 802.11n and you will find it in Lion and anything else you try.