How do I connect to the servers?

From the site: click Connect on a server in the home page list. CS2 launches and joins it.

From the console: open the console in game (~ key) and type:

connect IP:PORT

Use the copy button on the server card to get the IP and port.

If the console does not open, enable Enable Developer Console in Settings > Game.