They don't help in most states, all they will do is get a charging order against you. There are still companies that offer LLC asset protection services to those who don't realize that they don't protect anything in most states anymore....
I think there might be a misapprehension here. The limited liability aspect of an LLC refers to the fact that if there is a judgment against the LLC, it can only be executed against the LLC and not the member(s) of the LLC unless the judgment creditor can pierce the corporate veil pursuant to the applicable legal tests. That is real asset protection.
However, an LLC or other company structure is not intended to help in the situation where the judgment is against a
member of the LLC. If there is a judgment against a member of the LLC, it can be executed (through various procedural devices) against the LLC because the LLC is part of the member's assets. These company structures are not intended to allow the owner of a company to avoid collection of judgments against the owner.
Here's another more obvious example of this principle. Let's suppose you have $1,000,000 of AAPL stock. You are a co-owner of AAPL. If I obtain a judgment against you for $500,000, the Court can certainly order you to transfer your AAPL stock to me, or sell it and pay me the proceeds. The fact that you have your money inside AAPL does not protect it from me, a judgment creditor against
you. Conversely, if I obtain a judgment against AAPL, I could not execute it against you (although the execution of it against AAPL will reduce the value of your position in AAPL).
Note that there is a different body of law that governs who is liable for things in the first place. Let's suppose you trespass on your tenant's apartment because you don't understand the law relating to entering a leased property in which you no longer have a possession interest. Who is liable for this tort: you or the LLC who signed the lease, or both? That comes down to the application of the law of agency, which I'm not going to get into here. However, please note that the argument that you are personally liable for this tort is a much different argument from piercing the corporate veil (although the plaintiff may try to do both).
This is just general information and not advice. The details vary based on jurisdiction so this information should not be relied on.