Clicking the link should present the user with a page that they're now confirmed, but can't yet login as are awaiting admin approval. You should not be getting a login page. If you are then you've a misconfiguration with your CB Profile Joomla menu link (it must be public and published). Please see your documentation for proper configuration.