Pyramid scheme is implied because people try to get others to adopt bitcoin, may not friends and family but it is promoted to others as a way to get rich. Have you seen the various cryptocurrency sub-reddits? They often read like mass delusions or pump-and-dump schemes.
The only real value of Bitcoin that I have seen is the highly illegal darknet marketplaces, but outside of that I haven't seen much.
Regarding intrinsic value, there's one thing I hope from bitcoin (or any other crypto that could achieve that) : replacing my bank account. Banking services have got so bad with years, it's really time to disrupt them. Granted, we're far from there yet, and it may never happen. That's why it's a risky investment, with possible high reward (or high loses) and why ... it can't be used as a bank account (because of the volatility). Still going in the right direction, IMO.
Currencies are actually designed to slightly depreciate over time in order to get people to spend them on buying things or buying investments. That is done completely on purpose. Not too fast depreciation but not too slow either.
Bitcoin isn't depreciating, rather appreciating because of its design -- a limited supply.
What I often say, too, is that it's probably the only way it could have work. When bitcoin was very young and it was considered a currency, people didn't care. It's only when exchanges appeared and bitcoin started to get very volatile that it gained traction. Maybe having speculators getting rich and broke with bitcoin was the only way to bring cryptocurrencies to mainstream focus : during those frenetic times, everybody has heard about cryptos, and there's not a single day now without a news about a big actor (either administrations or corporate) trying something around cryptos or blockchains. Maybe we needed all of that to get the yet to be born crypto that can be used by everyone. Should bitcoin have stayed that weird internet currency nobody used, it would have died long time ago.