It confuses me as to why the Majestic did not receive an assault scope in the multiplayer, but has one in the single player.

Probably because of it's damage and accuracy.. people would use it as a primary