No, not necessarily. For one let's qualify that statement. Smart contracts on Ethereum are executed 100,000+ times by every node on the network, which is providing security and uptime for the network.
Some software transactions have external costs associated with them, such as financial transactions. Doing an international bank transfer may simply boil down to a credit in one SQL database and a debit in another SQL database but it still can cost dozens to thousands of dollars depending on the amount, and the situation. Even a VISA credit card transaction costs 1.5-3%. You as a consumer don't see that cost, the retailer is eating it though, and marking up their products and services to accommodate that fee.
But ETH transaction fees do not scale with the value of the transaction, it simply scales with the demand for the limited block space.
Ethereum community has been actively developing solutions for this problem, by developing optimistic rollups and zero knowledge rollups, which are effectively able to compress transactions and scale the network throughout by 100-1000x. Innovations like this will get Ethereum to Visa scale plus.
This technology is still early, but rapidly improving. Currently deployed rollups are in the 10-100x scale improvement range.
Some rollups currently in production:
https://arbitrum.io/ https://www.optimism.io/ https://starkware.co/