Deflationary ETH a long term death sentence?

I hear a lot of people saying that ETH will become deflationary after the merge, that is to say that new coin issuance will be less then the amount burned per new block. In the short term this seems good if you hold ETH, because less of it means it becomes more valuable. But long term, isn't it kind of silly to dwindle the supply? What happens when there's only 1 ETH left? Even if that took a hundred years, isn't it silly to deflate the supply just to make money? Sounds like a safemoon style gimmick purely to make money.

But probably I don't really understand it. I do think ETH is a great coin and I have a couple. Just not sure why deflating is so good.