Thanks! Your question is an interesting one: Forwarding TCP over LoRaWAN seems at first impossible due to large packet sizes (from LoRa perspective!). It turns out there have been some efforts to apply dictionary based compression methods to carry different protocols over LoRaWAN. You might want to check out RFC 8376 for details.
If you have multiple LAN Zigbee controllers, like a ZigStar UZG-01, you can use multiple instances of zigbee2mqtt and hook 'em all into Home Assistant.