Does a deflating supply of Ether the asset help or hurt Ethereum the network?
First, the important nitpick: Ether's supply is not inherently deflationary. It self-adjusts based on the following variables: number of stakers and demand for blockspace. Right now, the first variable doesn't come into play as the consensus is still achieved by proof-of-work, with 2 new ETH being issued roughly every 13 seconds.
During times of high blockchain activity, the rate of burning outpaces the rate of issuance. But in general, the supply still inflates, just at a lower rate than before EIP-1559 was implemented. In other words, Ether only becomes deflationary when it's actively being used. If deflation is bad for spending, then overall spending will reduce and it will go back to being inflationary.
After the network switches to proof-of-stake, the issuance will drop drastically (around 90%) and Ether should become deflationary for many years – possibly decades – until there comes a point where the rate of burning equals the rate of issuance. The best math available shows this will happen anywhere between 40 and 60 million Ether.
Let's address the next question that often follows: Why have fees if they're just getting burned anyway?
High gas fees are a result of limited supply vs. a lot of demand for blockspace. The cost of gas fees at any given time reflects the actual value of Ethereum's blockspace at that moment, as far as things can have value due to supply and demand. Anyone who is not in a rush to use the network can wait for the demand to go down and pay lower fees.
Reducing gas fees artificially would lead to "blockspace shortages" and make DoS attacks against the network cheaper. The mechanism behind EIP-1559 automatically adjusts the base fee that is burned depending on how full or empty the blocks are.
So why burn the fees? There are a lot of reasons to do so, but the easiest one to grasp in my opinion is this one: Since whoever creates blocks decides which transactions to include, the base fee cannot go to them as they could simply create dummy transactions to fill the blocks to artificially increase the fees everyone else has to pay. Burning the fees is a market-efficient way to avoid overpaying for blockspace, as was often the case under the first-price auction model before EIP-1559.
So, the higher the demand, the higher the fees. In that regards, you're essentially paying the network itself for using the product it offers: secure, credibly-neutral blockspace. (Side-note: there is a small premium you can pay to block creators to prioritize the inclusion of your transaction, but in general, around 80-90% of the fees you pay will be burned)
By virtue of holding Ether as an asset, the value created by people using the network flows in part back to you via this burning mechanism.
Next, let's address the core of the question: why would you spend Ether today if it's gonna be worth more later? Simply put: it's not meant to be a currency for day-to-day usage. I would argue that the existence of Ether-the-asset only serves to achieve the following two goals:
Any other use-cases you may imagine – collateral in DeFi, speculation/trading, store of value, even using it as money — are direct results of the open and permissionless nature of Ethereum coupled with Ether's inherent scarcity and value. But as a rule of thumb, the eventual "Ethereum utopia" does not entail buying a loaf of bread for 0.000784 ETH and paying five times the amount in gas fees. Anyone who argues otherwise is either misinformed or willfully spreading misinformation themselves.
Ethereum-the-blockchain provides a product and a service, and you have to pay for it with Ether-the-asset.
As a concrete example, if VISA wants to use Ethereum as a secure layer for settling transactions, and blockspace currently costs $X per byte in USD, then VISA will buy $X's worth of Ether for every byte they want to commit to the chain. Settling their transactions will burn that amount of Ether immediately. It doesn't matter that this $X's worth of Ether might double in the next year, they need to use Ethereum's blockspace today so they buy it. And they burn it. Increased buying pressure and downward pressure on supply!
Sooner or later a lot of people/institutions will be buying-and-burning Ether to settle any arbitrary data/computation on Ethereum. They don't have to care about it as an asset, it's just a medium to pay for blockspace. The existence of Ether-the-asset is basically nothing more than a necessary tool derived from a self-sustaining and self-adjusting network that doesn't depend on any one central entity deciding the price of blockspace nor even any one government that controls and issues the currency in which the blockspace is paid!
With that in mind, Ether is a utility coin first and foremost, and its value is tied to the value of the blockspace it offers. The fact that it's gonna increase in value over time as it becomes scarcer and captures value through burning only helps Ethereum's interests:
If Ethereum's blockspace becomes valuable – and I believe it will – it's inevitable that Ether will become a part of every major institution's balance sheets at some point because that's the most cost-efficient way to use it.
In fact, that's not true. There is a more cost efficient way to use it: Buy a lot of Ether, stake it and get 5-8% return a year, denominated in Ether. This is good for VISA as they're essentially getting Ether for "free" – after the initial capital investment and taxes – and it's good for Ethereum because more stakers means more network security. VISA using Ethereum as a settlement layer means their interests are aligned with Ethereum's well-being, and the same goes for all the other institutions that do the same.
I personally think it's extremely bullish for Ether as an asset to picture people paying for things in fiat or stablecoins using a VISA credit card, without even knowing that Ethereum is being used indirectly under the hood to settle that transaction, which burns Ether. But of course, this VISA example is just an easy one. There are many other use-cases for Ethereum's blockspace, such as DeFi, NFTs, gaming, or blockchains leveraging Ethereum's security in the coming "Layer 2" ecosystem.