The PS Plus requirement applies to all online multiplayer game modes. Whether you want to squad up in Call of Duty or race friends in Need for Speed, you'll need PS Plus. The subscription is tied to your PlayStation Network account, so it covers online play across PS4 and PS5.
Players will not require a PS Plus subscription to play Modern Warfare 3.