When you point your query to the pihole ( nslookup pihole.lan 192.168.178.51 ) it works as intended. When you don't it goes to an external dns provider which belongs to ZIGGO-INFRA / Vodaphone NL. ( 2001:b88:1002::10 ).
This would indicate a router setting where perhaps the router is not pointing to the pihole or perhaps the router is providing its own DNS servers in addition to what you set. Either way, I would look at your routers settings.
Looking at article you linked it sounds like one solution was to add IP Rules to block the IPV6 Traffic and force IPV4. I'm guessing thats what you mentioned did not work.
I found this article where the ziggo provided a user with a new boot file / firmware to disable IPV6. See article here.
Seems like Ziggo really doesn't want its users to have control.
For other persons dropping in here through search engines:
The trick was this:
a. The router does not allow you to fill in any local IP4 addresses when choosing to set your own DNS servers so filling in the pihole server is not possible (c.q. changing this screen) or changing the DNS :
b. However ... since it does not matter which IP4 address you fill in here (because anyways the pi is the DNS server) you can fill in anything in these IP4 fields and then fill in the IP6 fields the values of the GUA (Gloal Unicast Address) of the PI. (run ip -6 addr show). So it is a counter intuitive trick
(the GUA general remark on occasional loss when Ziggo changes and requires to reconfigure is a consequence but logical)
With this configuration it works, clients now get purely the pihole dns servers.