If you connect a PC to the ISP modem with the same cable you put into Nest Wifi WAN port, what happens? Does it get internet? What IP do you get, a global one or local/ RFC 1918 one?
Setup guide for reference:
Also some info on double NAT, if that is the case here: