Will demand for computing ever go down from where it is now? Even if the AI bubble temporarily pops, in the long run I think the demand for computers will be practically infinite.
Market forces will probably bring the price of hardware down in the next decade. Whether it is in a form that is useful for regular people/hobbyists is another question. If not, then hopefully the "cloud" starts to look a lot different.