Deflation means that I can make money (or more precisely, value) simply by leaving what I have in cash. That doesn't promote investment; it promotes hoarding.
That's the same as investment. If a part of society's resources aren't directed towards consumption, they are directed towards enabling future consumption. It's a tautology in economics that savings equals investment.
It's the same thing in economics. It causes the government to print more money to make up for the money missing from circulation, which will be invested. If the government doesn't do that, it increases the value of all other money in circulation.
But that’s under some weird, incorrect model of how money works. Presumably if we go down this route any further you’ll start talking about IS/LM and the money multiplier. All models are wrong, but there’s a better model that involves capital constraints and the Basel accords.
In any case, one of the major failings of modern macro is to assume you can think your way around the implications of economic actions. You have no way of knowing the consequences of stashing money under a mattress unless you actually do it, and even then there’s no guarantee the effect will be the same across different economies and in different eras. The world is just too complex for that.