The charging order will attach to any distributions that the LLC would make to you. While that might not immediately give the creditor access to what the LLC holds, it also means that while the charging order is in place YOU can't get any assets from the LLC either. So eventually you'd have to satisfy the creditors before when you want to take anything out of it. And all the while interest on the judgment will pile up. 

And if you use the LLC as essentially an extension of your own finances the creditors can use that to break through the LLC barrier. If the LLC is not conducting business but is essentially just an extension of your private finances that may create a risk for you in that regard. 

Note too that the state law won't protect you against the creditors forcing you to bankruptcy court and the bankruptcy court, being a federal court acting under federal bankruptcy law, could force the transfer of your interest or liquidation of the LLC and thereby allow your creditors to reach the assets inside it. 

So while it puts some hurdles for creditors to reach the LLC assets, it also limits you too. This is why you don't see more people doing it.