Looks like Pihole is working when accessed from your device at 192.168.0.201.
Whatever device is at 192.168.0.64 is sending requests to the Pihole as well, but I don't know what device that is. If you accessed msn.com from your iPhone during this logged period you've shown, the iPhone doesn't seem to be using Pihole for DNS for those queries.
The takeaway is that you're going to want to determine what device is using which DNS. iPhones show their configured DNS under Settings/Wifi then clicking on the Info button by the SSID you're connected to, Configure DNS. The DNS servers will be listed on "Configure DNS" details screen. If they're not what you're expecting, you can switch to Manual on this screen and enter the address of your Pihole (at least for testing).
That is exactly what I did, the 192.168.0.64 is actually the iPhone ip address, DNS was configured automatically to 192.168.0.170. When I saw that this did not solve the problem I added it manually. Even with it being available manually sometimes it does not use this DNS. That is what I think atleast because it doesn't always show under query log in Pi-hole.
One of your previous screenshots shows that you have explicitly disabled IPv6 on your Windows machine.
However, your debug log shows that your network has indeed full IPv6 connectivity:
*** [ DIAGNOSING ]: Name resolution (IPv6) using a random blocked domain and a known ad-serving domain
[✓] smetrics.home.kpmg is :: on lo (::1)
[✓] smetrics.home.kpmg is on eno1 (fe80::<redacted>)
[✓] No IPv6 address available on wlp1s0b1
[✓] doubleclick.com is via a remote, public DNS server (2001:4860:4860::8888)
Together with your observation that none of your iPhone's DNS requests are registering in Pi-hole, that would strongly suggest that your iPhone would use another DNS server, most likely your router's IPv6.
You should be able to verify that by re-enabling IPv6 protocols on your Windows machine and rechecking its ipconfig DNS servers.
You can check what DNS server(s) is/are advertised via router IPv6 RA (Router Advertisement) if install below on the Pi-hole or other Linux host:
sudo apt install ndisc6
$ apt show ndisc6
Description: IPv6 diagnostic tools
ndisc6 gathers a few diagnostic tools for IPv6 networks including:
- ndisc6, which performs ICMPv6 Neighbor Discovery in userland,
- rdisc6, which performs ICMPv6 Router Discovery in userland,
- rltraceroute6, a UDP/ICMP IPv6 implementation of traceroute,
- tcptraceroute6, a TCP/IPv6-based traceroute implementation,
- tcpspray6, a TCP/IP Discard/Echo bandwidth meter,
- addrinfo, easy script interface for hostname and address resolution,
- dnssort, DNS sorting script.
If you run below one, it will show you the MAC address from which the RA is coming from, the IPv6 prefixes and DNS server(s) advertised:
Maybe it needs sudo in front of it or root powers for your distro.