Its your game and your table.

And the reality is sharpshooter is very powerful.

And yes being able to shoot someone from 90ft out before they even get to you... probably means they are almost dead.

Henry V knew what he was doing

Honestly the weapons in 5E are a mess.

I really do not know how effective and powerful a longbow is at 10ft or at 100ft

But I'm not sure gimping ranged helps, because ranged attacks are powerful.

How do your players feel about this? Is this important to them.

Crossbow expert take a feat, and therefore expensive, it might be 8th level.

Something I used in combat (like 1E)... if you miss your target by more than 5 (or 10) (think of a fair number) with a ranged attack.... you run the risk of hitting an ally within 5ft.

You could take this rule and expand upon it... for every say 30ft, that 5 becomes a 4, then a 3, etc... this increases the risk of launching arrows 120ft away while the paladin is engage in melee with the target.