Not sure if these will help, but here's two ways I've solved sliding in my own projects:
The first is I set the velocity 2D of the rigid body 2D to 0 every frame when the object is in its idle state.
The second is to apply a physics material 2D (right click in project -> create -> 2D -> physics material 2D) to the rigid body 2D and pump up the friction.
Hopefully one of these helps. Even small issues can be a huge pain, good luck haha.