Connect a second controller and have player two join from the Rocket League main menu. The join button depends on your platform and, on Switch, on whether each player uses a single Joy-Con or a full controller.

PlatformPlayer 2 controllerWhat player 2 does
PlayStationSecond controllerPress the PS button and sign into a profile, then press Options (Epic labels this Settings).
XboxSecond controllerSign into a full Xbox account, then press Menu at the main menu.
Switch, one Joy-Con eachSingle Joy-Con per playerPress Minus, pick a Nintendo account or temporary local profile, then both players press SL + SR.
Switch, two Joy-Con or Pro ControllerFull controller per playerPress Plus, pick an account or temporary local profile, then both players press L + R.
PC, Epic Games StoreSupported DualShock 4Press Options.
PC, Epic Games StoreSupported Xbox One controllerPress Menu.

Console details worth knowing

On PlayStation, an unsigned PSN guest is limited to offline play. For Xbox, sign player two into a full Xbox account. Switch supports up to two players handheld and four when docked.

PC details worth knowing

On PC, connect both pads before launching the game. The Epic Games Store split-screen guide lists DualShock 4, Xbox One and Xbox 360 controllers, and gives the join buttons for DualShock 4 and Xbox One in the table above.

Verify it worked

Check the party lobby after player two presses the join button. If you see only one car or name, return to the main menu, confirm that the console or PC recognizes the second controller, and check which profile the controller is signed into. On Switch, confirm the controller layout with the button pair for your setup.

If you each have your own console or PC, use the cross-platform party guide to join each other online.