Charging orders are either discharged by the creditor or dismissed by the court themselves.
A form K restriction can be withdrawn by the creditor, cancelled by the debtor/owners or automatically cancelled when overreached for example following a sale and where it has been complied with 0 see PG 76 section 4
When a property is sold the restriction has to be complied with and if it is then it is usually automatically cancelled as it has been overreached. The new owner does not 'inherit' the beneficial interest/debt
I'd recommend seeking legal advice here to understand what having a charging order actually does and how it impacts on both the debtor, whether they own a property or not, and what powers of enforcement it actually gives you as the creditor - in my experience it doesn't work in the ways you are suggesting
Perhaps try
Charging orders | National Debtline for a wider understanding