Ah finally some progress, the first command failed with no response, the next two commands worked fine.
Edit: Actually maybe not, the output below is from the non-working pi-dns-2, but running the commands on the working pi-dns-1, the output is the same.
root@pi-dns-2:~# dig retrogamingcables.co.uk @192.168.0.12
; <<>> DiG 9.11.5-P4-5.1-Raspbian <<>> retrogamingcables.co.uk @192.168.0.12
;; global options: +cmd
;; connection timed out; no servers could be reached
root@pi-dns-2:~# dig retrogamingcables.co.uk @84.200.69.80
; <<>> DiG 9.11.5-P4-5.1-Raspbian <<>> retrogamingcables.co.uk @84.200.69.80
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: SERVFAIL, id: 225
;; flags: qr rd ra; QUERY: 1, ANSWER: 0, AUTHORITY: 0, ADDITIONAL: 1
;; OPT PSEUDOSECTION:
; EDNS: version: 0, flags:; udp: 4096
;; QUESTION SECTION:
;retrogamingcables.co.uk. IN A
;; Query time: 32 msec
;; SERVER: 84.200.69.80#53(84.200.69.80)
;; WHEN: Mon Jul 06 19:53:00 BST 2020
;; MSG SIZE rcvd: 52
root@pi-dns-2:~# dig retrogamingcables.co.uk @8.8.8.8
; <<>> DiG 9.11.5-P4-5.1-Raspbian <<>> retrogamingcables.co.uk @8.8.8.8
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 26691
;; flags: qr rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 0, ADDITIONAL: 1
;; OPT PSEUDOSECTION:
; EDNS: version: 0, flags:; udp: 512
;; QUESTION SECTION:
;retrogamingcables.co.uk. IN A
;; ANSWER SECTION:
retrogamingcables.co.uk. 3599 IN A 213.230.222.4
;; Query time: 156 msec
;; SERVER: 8.8.8.8#53(8.8.8.8)
;; WHEN: Mon Jul 06 19:53:10 BST 2020
;; MSG SIZE rcvd: 68
Output from pi-dns-1
root@pi-dns-1:~# dig retrogamingcables.co.uk @192.168.0.11
; <<>> DiG 9.11.5-P4-5.1-Raspbian <<>> retrogamingcables.co.uk @192.168.0.11
;; global options: +cmd
;; connection timed out; no servers could be reached
root@pi-dns-1:~# dig retrogamingcables.co.uk @84.200.69.80
; <<>> DiG 9.11.5-P4-5.1-Raspbian <<>> retrogamingcables.co.uk @84.200.69.80
;; global options: +cmd
;; connection timed out; no servers could be reached
root@pi-dns-1:~# dig retrogamingcables.co.uk @8.8.8.8
; <<>> DiG 9.11.5-P4-5.1-Raspbian <<>> retrogamingcables.co.uk @8.8.8.8
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 46534
;; flags: qr rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 0, ADDITIONAL: 1
;; OPT PSEUDOSECTION:
; EDNS: version: 0, flags:; udp: 512
;; QUESTION SECTION:
;retrogamingcables.co.uk. IN A
;; ANSWER SECTION:
retrogamingcables.co.uk. 3599 IN A 213.230.222.4
;; Query time: 166 msec
;; SERVER: 8.8.8.8#53(8.8.8.8)
;; WHEN: Mon Jul 06 19:59:48 BST 2020
;; MSG SIZE rcvd: 68