The issue I am facing:
Hello. So currently I am trying to visit a specific website but however the website won't load. I suspected it has something to do with the IPv6 return NODATA-IPv6 but the IPv4 does return a valid IP. As I research deeper about IPv6, apparently both A and AAAA queries can be resolved over IPv4 DNS. So I don't think that I didn't use any IPv6 DNS resolver should be an issue. So I am not quite sure what to do.
From your outputs, it appears Pi-hole is correctly resolving the domain you have requested.
This would infer that the problem is outside of Pi-hole. But, you can use these tools to determine if Pi-hole is blocking any domains that are needed to access your desired content: