As you see, you lose only online achievements and official matchmaking. Everything else—including split-screen co-op (via mods)—is intact.