Zigbee has always (or at least, for a long time) targeted a mixture of consumer and industrial applications and is focused on relatively short range mesh networks. It does have a lot of consumer uses now, it's one of the big protocols used for home automation. Not sure of the exact history of LoRa, but widely distributed oil well sensors would definitely fit the intended use of LoRa. Agriculture is another good use case.

Low power sensors infrequently reporting (mostly one-way) small amounts of data back to a base station over really long distances is what it was originally designed for, though people have done other stuff with it. Zigbee is all about the meshing AFAIU.