Answer is that CB updates and uses the Joomla user creation API, but keeps extra info/data in its own tables. So if you remove CB in the future your users will still be in the Joomla user database.
You can of course test this out as CB is free to download.