Are we talking about PieFed the software or piefed.social the instance? We should seperate development cost from hosting cost.
If PieFed the software grows to 1M users and the users are distributed across a lot of instances, the cost for hosting is split between all instances.
If the instance piefed.social grows to 1M users we have a different problem and that is centralization.