Ok, so lets see how many of these I can capture...
First, Google "Google NS Servers" and you will find a number of articles talking about their two IP Addresses for their "Public DNS".
If you have an IP and want to know what it's hostname is, in Terminal, type "nslookup 8.8.8.8" and it will return the host name google-public-dns-a.google.com. By virtue of the domain "google.com" you know this host google-public-dns-a is within the google.com authoritative realm. So, for those others in your list, you can repeat to see what they are. But remember, the first DNS server that can resolve your query will stop the search, so adding more DNS servers won't help speed things up, they will probably never be used in practice.
You really only need the two google DNS servers. Most likely, these two addresses are addresses for a load balancer in two data centers, with several actual DNS servers behind these balancers. So, with the two addresses, if one data center is offline, the other should be online, and if one of the hosts is offline, the others can respond. The uptime for the Google DNS servers is probably as close to 100% as possible in the internet world, and may be one of the only real benefits of google DNS versus your ISP.
DNS is a hierarchical database that is implemented at various levels across the internet. The top level is .com, .net, .org, etc. At this level, any registered domain is recorded along with information you can sometimes get by typing whois google.com or whois comcast.net, etc (some domains choose to keep this info private). This tells you details about who registered the domain, how to contact them, etc. Included in the top level registration information is the authority for the domain, meaning the Name Server (DNS) that can resolve specific host names within the domain. For instance, google-public-dns-a is a host within the google domain. When you typed nslookup, your query went to the first DNS server in your chain that knew the answer. If none of your DNS servers knew, .com would have queried the authoritative server for the google.com domain to find that host. But, if any DNS server between you and .com knows this answer (because it recently did the lookup form someone else), it stops the chain and returns the answer to whoever requested it, who in turn responds to it's requestor and so on. DNS caches contain a Time To Live (TTL) that will drop the entry from cache over time to ensure the information is current. So, lower volume servers may not be cached anywhere and have to go all the way through the chain to resolve the hostname.
When your browser takes your input for a url, it parses the host + domain information from the URL (mail.comcast.net for example) and looks in /etc/hosts for the IP Address. If it doesn't find, it then looks in your local DNS cache (which would be there if you had previously tried to connect to this host). If no answer in cache, it then follows your resolver instructions (with *nix computers this is a file in /etc/ called resolv.conf but macOS actually uses a command scutil --dns to to get your resolver settings. From this, it knows to use the DNS server(s) in your network settings that were either statically configured or obtained from DHCP.
So, lets talk about DHCP for a minute. Dynamic Host Configuration Protocol (DHCP) is a simple way to configure hosts on a network. When a host starts up the network processes, it looks to see if an IP Address is statically assigned to the network interfaces that are configured to be active on your machine. In the case of a Mac or PC, this will typically be the WiFi and Ethernet interfaces. In the case of your router, it is the WAN Ethernet port. If there is no static address assigned, it sends a DHCP discovery broadcast out to the network and hopes there is a DCP server somewhere that will respond. In most cases, this is your home router, though in more complex networks, it might be a server such as a Windows 2016 Server with DHCP services, a macOS Server, a Linux or Unix server, etc. In the case of your router, it is the ISP network that responds.
A DHCP server will generally provide an IP Address to any host that asks for one (your ISP actually filters by MAC Address to ensure the Modem is registered as an authorized device). It also provides some additional information such as domain information, the router IP Address, and DNS servers. For IP phones, a lot of configuration info can be passed using DHCP, such as the server to register to, the server to get settings files from, etc.
Your Time Capsule simplifies a lot of this by responding with an IP Address for the requestor, along with the router IP Address (itself) and DNS server (itself). The TC also queries the Mac, PC or any device requesting an address to get it's host name and then caches it for future use. So, lets say your Mac is named "iMac" (in your sharing properties). The TC would create a DNS cache entry for iMac 192.168.1.10 for example. Now, if any host on your network tries to access iMac (for file sharing for example), the router would provide your IP Address to the host trying to make the connection. This is done dynamically, and stored in the router's DNS cache, so you never see it.
Your TC does something similar when it starts up. It will see no static IP (but maybe static DNS) and send a DHCP discovery to your ISP. Your ISP will return the domain, an IP Address for the WAN port on your router, and DNS servers. If you statically assigned DNS servers (Google), TC will ignore the DNS servers from your ISP. Your TC also has a static LAN IP Address (192.168.1.1 I assume) which is set when you specify the DHCP scope for your network (it picks .1 for itself and then provides addresses in the range you specify.
Ok, so back to the URL in your browser. So, your Mac didn't have any idea locally about the address for mail.comcast.net. So, it sees the TC as the only DNS server it is aware of (because of DHCP and no static DNS servers configured on it). So it sends a DNS query (actually "nslookup mail.comcast.net") to your TC. If the cache in your router knows this from another attempt to reach this host, it answers. If it doesn't know, it does an nslookup to it's DNS servers (either from the static assigned, or if you are using default, from the DHCP provided DNS servers). So, then your ISP does what your router did, look in cache, then send an nslookup to it's upstream DNS servers and so on. Again, at any place in the process, if an answer is known, it is returned and the chain reverses till it reaches your device. Your device then sends the
http://ipaddress/whatever with the ip address it got from nslookup to fetch the website. It works similar for other network protocols like FTP, SSH, SCP, etc.
So, tying it all together, Since Google Name Servers are commonly used by a lot of users, including ISPs, they often know more hosts than your ISP does. But, if your ISP is large enough, the Google servers will be no faster than your ISP. By using Google's DNS servers on your router, or Mac, you are making the assumption that they will be faster, or more reliable than your ISP.
In reality, most of the large ISP DNS servers are probably going to do the job just fine. Google MAY be slightly faster because they are used more than the others, but if you run an nslookup with different DNS servers configured, you probably wouldn't notice the difference, it happens that fast. Which is to say, changing DNS servers won't make a slow ISP connection that much faster that you would notice. Where it does make a difference is with obscure sites that are not accessed as often. Since many ISP may use Google to resolve unknown hosts, Google MAY return results faster. Certainly, google will go direct to .com level where your ISP may go to google first.
By statically assigning Google DNS on your router, and letting DHCP tell your devices to ask the router for name resolution, you are simplifying configuration by doing it once on the router instead of manually on each device. Bypassing your router by manually configuring DNS on every device is both time consuming, and will only shave a couple of milliseconds off of queries so, more hassle than it is worth probably.