Range units are just much more superior than poor melees. It was that way in CiV5 and more so in CiV6 because of the new movement rule. Unless 1. they significantly nerf archer's melee to a point where melee can one shot them or 2. they change the archer range down to 1, there is no way to balance this out with the new movement rule