The MSQ is not going anywhere because it forms one of the three main pillars of FFXIV's overall concept... the over-arching main storyline is one of the elements that makes it a superior MMORPG on a global level.

As mentioned a few times in this thread, if you find the MSQ unpalatable and not to your liking, please purchase some skip potions.