It is a bit confusing, but that paragraph is talking about resource providers in general with one type being the dynamic provider described on the rest of the page. The “third type of resource provider” mentioned is a standard resource provider. For example, you can write your own native provider (see
https://github.com/pulumi/pulumi-provider-boilerplate) then share it via something like artifactory or similar.