Why call it secondary then, that’s so counterintuitive lol

I don't think that's even the official naming. It probably comes from what Windows 95 called it back in the day:

On Linux, it's just an additional "nameserver x.x.x.x" line in /etc/resolv.conf, with no indication of which is the "primary" or "secondary".