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.