Debt just shifts resources around in the present, but can't magic new resources into existence.
(Unless you borrow from foreigners, which taps resources from outside the country that later have to be paid back. But I'm not sure the Apollo programme was financed with foreign loans?)
Interest and repayment of the debt happens in the future. Though the government does sell bonds to individuals and organizations, much of the financing comes from the federal reserve.