If you connect a PC to the cable modem, that is the machine that will work until the ISP resets or the cable modem is reset. Moving the ethernet cable to the next machine or router fails here.

Also, another person had that exact ping failure. They didn't use the router defaults and had enabled AP ISOLATION.

Small details like that matter.