It doesn't work because the view you specified doesn't exist. The non-SEF profile URL is as follows.
My Profile:
index.php?option=com_comprofiler&view=userprofile
Users Profile:
index.php?option=com_comprofiler&view=userprofile&user=USER_ID_HERE
If you're using CB Content Bot to allow substitutions in Joomla articles you don't need to do manual construction as we've a substitution for some URLs. Example as follows.
{cb}[cb:url location="profile_view" /]{/cb}
See the below substitution tutorial for further substitution usage information.
www.joomlapolis.com/support/tutorials/107-use-cases/18353-using-substitutions-throughout-cb