What else is needed to create new tab for content in extension?
As the example says, "you would create a url which would return an html snippet".

Since this is in the context of a CiviCRM extension, please see the Civix documentation for how to create a basic page.

The url of your tab should be whatever you decide the url of that page should be.