That's a core problem of DnD and other systems like it, you can fail dice rolls, a lot. Leads to immersion breaking stuff, if you fight a truck sized monster, stand direcly before it and miss a hit, that's obious bull... But there is no easy way to fix this as combat kinda needs an element of randomness. Otherwise your weapon is e.g. a fixed 15, the enemy has an armor class of 16, you'll never do damage until you find a better weapon. And than you don't need to go into battle either, because you will win, no matter what. Completely eliminating the feeling of having just overcome a challenge. That's why I normally prefer action RPGs like Elden Ring because the randomness comes from my skill as a player.