Weight affects how you'll be affected in contact with another player. A heavier play will knock a lighter player out the way when they collide. If Wario were to bash Shy Guy for example, shy guy would be knocked pretty far. Conversely if Shy guy were bash into Wario, he would not move too far.