Good technical detail about the issue I mentioned my home network was facing with my Pixel 2 earlier:
Following initial research and investigation, our Engineering Team is confident that they’ve determined one of the key origins of the issue. From what we have gathered so far, the issue appears to be related to some recent releases of Android OS and Google Apps. This issue stems from these devices’ “Cast” feature, which sends MDNS multicast discovery packets in order to keep a live connection with Google products such as Google Home. These packets normally sent in a 20-second interval. However, we have discovered that the devices will sometimes broadcast a large amount of these packets at a very high speed in a short amount of time. This occurs when the device is awakened from the “sleep mode”, and could exceed more than 100,000 packets in a short amount of time. The longer your device is in “sleep”, the larger this packet burst will be. This issue may eventually cause some of router’s primary features to shut down – including wireless connectivity.
Turns out the issue was at both ends—Google’s end where their devices push out a huge packet burst that most routers cannot handle and on router manufacturers’ end that their routers either restart or just hang when faced with that packet burst. Thankfully, after installing the firmware update that TP-Link has since released my home network is working fine again.