Problems with Duplicate Subscription Charges and Refunds

I've been a loyal Apple user for years, and I've usually found their subscription management to be pretty reliable. Recently, I wanted to renew my subscription when I noticed a great promotion for half off for the next three months. So, I went ahead and took the deal without thinking much about the rest of my subscriptions. The next morning, I saw that my old subscription at the regular price was canceled, and the new, discounted one was there too, so I assumed Apple handled everything correctly. However, I ended up being charged twice for the same subscription. I reported the issue through Apple Wallet and contacted Apple support right away. At first, they seemed optimistic about issuing a refund, but after waiting, I received a decision stating I was not eligible for a refund. I've since appealed this decision with more details, but it still shows as 'not eligible.' I even reached out to the vendor I've been with for years, but they just redirected me back to Apple. I'm really frustrated with this situation and feel like something needs to change.