Question about Monero node on a local network

With that in mind, would the LAN ip address (192.168.x.x) be better than 0.0.0.0?

no, not better

Can I still use 0.0.0.0 if I want to make the node available for others to sync their nodes?

for --rpc-restricted-bind-ip? yes. It is what i recommend

edit: do you mean “for other nodes to sync their nodes”? If so, youre asking about --p2p-bind-ip and that is already set to 0.0.0.0 by default.