Thank you.
Windows ping options do indeed differ from Linux, where -n would mean numeric output only and not accept a parameter.
No, as mentioned for the third time, .local is completely unrelated to DNS. mDNS is a separate protocol, and it applies to IPv4 as well as IPv6.
It seems you are wrongly assuming Pi-hole would use mDNS names, and you are wrongly assuming that your .local names would apply to IPv6 only.
You will never see .local appearing in your Pi-hole's Query Log (assuming your network makes correct use of mDNS, and you don't deliberately send requests for such a domain).
And there will be IPv4 as well as IPv6 addresses associated with your xps.local name - check ping -4 xps.local vs. ping -6 xps.local.
But again: That resolution happens completely independent from DNS in general and Pi-hole in specific.
Now, that's different from expecting to see xps.local as client name for a DNS request originating from an IPv6 address.
A DNS request does not contain the requester's hostname, it carries only the requester's source IP (as that's where the reply should go to).
Instead of displaying the original IP in its Query Log, Pi-hole can augment readability by displaying the hostname associated with an IP.
While this would allow to associate a name to an entry in the Query Log, this may produce multiple entries of the same name in statistics that would aggregate by source IP, like the one you've observed.
The interesting question for your case is why any client would send queries to Pi-hole originating from an IPv6 address at all.
Your debug log shows that your router advertises two public IPv6 DNS server addresses:
*** [ DIAGNOSING ]: Discovering active DHCP servers (takes 6 seconds)
Scanning all your interfaces for DHCP servers and IPv6 routers
Timeout: 6 seconds
* Received 96 bytes from fe80::<redacted> @ eth0
(…)
Recursive DNS server 1/2: 2620:119:35::123
Recursive DNS server 2/2: 2620:119:53::123
DNS server lifetime:900 sec
Source link-layer address: <redacted>
While there is no sign of your Pi-hole's host machine's IPv6 address, this poses a more serious problem, as it would allow your IPv6-capable clients to by-pass Pi-hole completely.
You should reconfigure your (TP-Link?) router to not advertise IPv6 DNS server addresses.
But that still leaves the question:
How did your clients named xps and gram get to know your Pi-hole host machine's IPv6 address? Did you perhaps manually configure them to use it?