Local Multiplayer means that the game can be played offline, and you can played it either as a co-op game (a.k.a your other player is helping you), or as your opponent. And if the game only listed “Local co-op” as its feature, then you can't play against the other player, like fighting or sports games.