A youth football coach accused of shooting two people during a game has been cleared of all charges, including attempted murder.