it will change but not drastically
while lightning network will increase the number of transactions per second, it won't get anywhere near
the numbers visa or mastercard manage
Not drastically? LN can ultimately handle millions of transactions per second as a globally deployed network. It all comes down to how many nodes there are online, and how many funded channels they have open.
That's the benefit of not having to deal with the main chain. The more LN nodes and funded channels, the more throughput the second layer will have. The only obstacle right now is the routing aspect, but I'm sure it'll be sorted out.
Overall, literally anything is better than Bitcoin's current ~7 TPS throughput. The ultimate goal is to have people leave their channels open and buy their coins through an exchange allowing them to withdraw through LN.
It's going to take a couple of years for sure, but it is likely going to happen.