Went through similar with my PlayStation account about a decade ago - couldn't figure out how to switch it from a UK card to a US one

Tried a few things, but eventually just gave up and opened a new account (fortunately I hadn't made many purchases)