When you are playing a local multiplayer game, you use a different account for each DualShock. I think the purpose of turning off the controller is to keep playing singleplayer. Because otherwise, it wouldn't be possible to sign out from the second player's account and turn off the controller at the same time.