Not generally. It generally refers to first names more than surnames. It also strongly implies that you actively want to kill the name off, not just move to the new one. It’s changing names with prejudice against the old one.
Refering to someone by their maiden name is generally not considered insulting. Dead naming someone (after you’re aware) is extremely insulting.