yes but that tranfer fee is the same for 100 or 1 billion in value, and lightning correctly implemented pushing that fee down to the subcent number.

One of the biggest misconceptions around Bitcoin is somehow that it was supposed to sort all this out before it bootstrapped to a large enough network, but we all know that´s impossible.