That's the confirmation URL sent with the Pending email as configured within CB > Configuration > Registration. The best I can suggest is to create a Joomla menu item to CBs profile page that's public and published then append its Itemid to the [CONFIRM] substitution in the Pending email. Next assign modules to that menu item. Example substitute usage as follows.

[CONFIRM]&Itemid=42

Aside from that, no there's no way to do it as that task does not have a menutype. With CB 2.0 there's new triggers added and you'll be able to redirect easily when an account becomes active using CB Auto Actions. So you could for example with CB 2.0 redirect to a Joomla content article with custom article text and modules displayed as needed.