Right now light and heavy is only relevant in terms of how much weight it takes up in your inventory.

A light crossbow is like 3kg, but a heavy crossbow is 11kg off your inventory. In a way, you are trading the extra damage potential for inventory convenience.

A very uninteresting, bad, outdated system. Not sure why they still insist on a carry capacity, all it does is discourage you from exploring and looting.