New to all this, but not the game itself

Hi there, consider me a newbie, when playing this game is this like a multiplayer game online or as i used to have it years ago, a stand alone game, ie, just myself playing it?

Depends on what content you want if I understand it correctly.

Coop Missions despite its name can basically be played as solo content while viewing your partner as flavor unless youre going for Mutations or Brutal+.

There is single player content in the Arcade aswell if youre willing to search through it.

Due to time constraints I do not have time to play multiplayer but if youre interested in it then you can check the ladder yourself to see the queue timer.