Hi,
It is correct. Basic SharePoint module is a part of standard DNP license and free. Hosted Sharepoint comes with Enterprise solution but needs additional Hosted SharePoint license.
Basic SharePoint module creates web application and database for every site collection. It raises more resources from the server.
DNP Hosted SharePoint service creates host-named Site Collections on the top of SharePoint Web Application (we call it "Root Web Application"). The method allows you to host thousands of SharePoint sites on single server.
You create Root Web Application manually and then tune Hosted SharePoint service to use it. You can use more than one Root Web Application and Hosted SharePoint service - for example SSL and not SSL, or with wildcard certificate or without it. Something similar to Exchange Storage Groups / Databases and different Hosted Exchange services connected to it. However in most cases it is completely enough to have one SSL-protected Root Web Application. This module was developed, tested and officially supported with WSS 3.0.
Also we do not plan to support basic SharePoint provider in future. Thanks.