Deflation causes people to hoard their money because it's basically an investment to keep it. That's not something that helps the economy (need them to spend money).
On the contrary, it can help the economy. If you want to grow the economy sustainably (and not just boost short-term metrics) then you need to expand its productive capacity through capital investment. You can't do that if everyone is focused on immediate consumption, so the first thing is to convince people to hold back on consumption and start saving instead. Deflation has that effect.
Once people have started saving, they can either hold onto the money or invest it somewhere. If they choose to hold onto the money, they may not be going out and actively picking profitable ventures, but neither are they using up any of the surplus production that money represents. Their "hoarded" money isn't competing with others' money for goods and services, which makes others' money that much more valuable. You can think of that as a sort of general loan, not of money per se but of purchasing power, part of which will go toward consumption and part of which will go toward investment. The portion of the decrease in prices (deflation) which results from those investments is the interest on the loan.
The interesting thing about a deflationary currency is the potential investments with nominal returns less than the rate of deflation, i.e. those which would naively seem to be profitable if it weren't for the deflation. If the change in prices is due to a policy of reducing the currency supply or a sudden, unexpected change in the demand for cash, that could be an issue, but when the deflation reflects changes in the natural price of money in the market—changes in the supply of goods and services relative to the (fixed) supply of money—then any investment which fails to beat the rate of inflation is a subpar investment, and would reduce economic growth, not increase it. The investments which don't take place due to inflation shouldn't take place, because they take productive capacity away from more profitable investments, even if the alternative is simply "hoarding".
If the deflation does happen to be due to a change in the demand for money, rather than economic growth, then that indicates an expectation there will be more need to spend money in the future more than there is now, which once again means that putting that money into lower-return investments now would be a costly mistake—it would mean wasting limited resources in the present when there will be more valuable uses for those resources in the future.
On the other hand, if the deflation is due to manipulation of the money supply, then that just comes down to sending false signals, and an economic loss should be expected. Deliberate deflation gives people an incentive to hold their money rather than make investments which would be better for the economy, just as deliberate inflation leads people to make investments whose low returns actually reduce overall economic growth.
To illustrate how currency inflation leads to malinvestment, let's say that annual growth in terms of purchasing power, the total supply of goods and services, is 3%. The money supply increases by 5% over the same period. Between the two, you should expect prices to increase by about 2%. Let's also say that there's an investment which pays 4% nominal returns. While obviously not the best investment out there (the average should be 8% based on the growth and inflation rates), it looks reasonable on paper—that's a 2% net increase in purchasing power, which is far better than the 2% loss you'd get from simply holding on to the money. However, the contribution to economic growth is actually -1%; 5% of that 4% nominal return came from the increase in the money supply. It only looks profitable because the economy was growing by 3% at the same time. Making this investment, or any other investment with less than 8% nominal returns, will slow the economy rather than contributing to its growth.
TL;DR: When deflation causes people to hoard rather than invest, it doesn't affect the value being invested, just the nominal amount of currency. What it does do it let the people who are competent to pick economically profitable investments do so without interference from others only looking for somewhere to park their money where it won't depreciate too much.