Likely only Reddit can say. I don't think Reddit was ever trying to make money off Community Points directly (in contrast to their NFTs), but rather to boost engagement. Whether or not it did, and by enough to offset the costs of starting and maintaining the system, we'll likely never know.