A South Australian MP described by a court as a "drunken pest" has been found not guilty of assaulting a fellow MP at a Christmas party in 2019.