Why can’t I make a purchase using my apple account balance

That is true. You would have to send a gift card from apple.com or some other gift card provider.

You must have a debit or credit card to purchase a subscription, because it is a recurring cost. Is that the problem?

What Apple account balance; in your iTunes & App Store, or your Apple Cash account?