You are correct. If the Pi-Hole is your only DNS server, if you disconnect it from the network you should lose internet connection.
I loaded the same site and saw no ads. I suspect that there is a setting in your browser or client that is allowing some of the DNS traffic to bypass Pi-Hole. The tools in this thread may help you determine which traffic is not being processed: