If you have one Apple ID account with one card linked to it, then that card should be used for fees.
Is it not possible to separate expenses to select payment methods. All charges will be tried with the primary payment method of that moment. If that fails or reached its limit, then any secondary payment method will be used, if entered. They’re ordered.
Change, add, or remove Apple ID payment methods - Apple Support
If there are multiple Apple ID accounts in use, then each account will have its own payment methods.
If you are in a Family Sharing group with Purchase Sharing active, then all group charges are billed to the payment method of the organizer.
If you are in a Family Sharing group without Purchase Sharing active, then the Apple TV+ subscription will be billed to the original subscriber.