Weight painting is acting wierd
A vertex can be in multiple vertex groups. I think that's why you groups look good but move like that : other associated vertex groups. You can see that in edit mode with the selected vertices in N panel, vertex weight with associated groups.



Here you can change weight or remove a group from the list of vertices associated groups