How to add Cloudflare SSL certificates to Nginx Proxy Manager?

No, it doesn’t. NPM is entirely capable of obtaining certs using the DNS challenge, which doesn’t require public access to any of your system.

The problem you’re facing is caused by the fact that Cloudflare’s certs are trusted only by Cloudflare. They’re intended to be used when you are exposing your site(s) to the world, and accessing them by way of Cloudflare’s proxy service. As you’re encountering, they’ll result in errors with any other use case.

Here’s how to set up NPM, with Let’s Encrypt certs, without public access to your apps:

I just wrote that up this morning; I’ve now added some screen shots as well.