Can two people play the GTA VI story together?

No. The story is for one player, with no announced co-op or split-screen mode.

ConfirmedChecked:

Both console stores list single-player play. Two playable protagonists do not mean two people can control them together.

Sources