A pyramid scheme pays out fake returns that were actually new investments, which requires unsustainable geometric growth. An asset bubble doesn’t depend on fraud or growth, it just keeps going until speculators’ confidence is shaken.
A pyramid is a more psychologically powerful scam as many people actually get big returns and become true believers. Made up assets are more akin to the tulip mania and such.