And this is TSR and later WOTC should have thought up weapons and ballistic skills like WHFRP should have been to prevent such an issue with racial ASI's, or at least Dwarves who aren't good (more so with bad Dex) with Crossbows despite being associated with them in fantasies.
(Though WHFRP is a lot different than DnD in terms of gameplay and idea, namely it had a literal lawyer and ratcatcher as character classes along with its origin as miniature war game.)