If you set up your DNS this way, some of the traffic won't go to the Pi-Hole, it will go directly to Cloudflare. The terms "primary" and "secondary" can be misleading; both DNS entries will be used.
Can you make a sketch of your network setup and post it here?