No. The Adventure Mode (Subspace Emissary) in Super Smash Bros. Brawl is strictly single-player. You cannot play it cooperatively with a second player.
For a full co-op campaign experience, later entries like Super Smash Bros. Ultimate's "World of Light" still remain single-player only—co-op is limited to Spirit Board battles and Versus modes.