Will credit card debts write off the debt after your death?

They will not do so immediately. They will attempt to collect from the estate. Debts are one of the primary reasons someone should open an estate. The estate has to pay off the debts. If the estate cannot do so, they distribute as best they can. If the court approves the distribution, the debts are ended.