I'd advise you to take breaks by doing other content, but I'm a big fan of a lot of story, so my "breaks" from the MSQ (I started in 2019) generally also involved me reading text. And there is a lot of text in this game!

Honestly, if it feels overwhelming but you want to play more, please don't listen to the loud minority and feel like you must read every little thing and watch every cutscene. Skip the dialogue, go back and watch important MSQ stuff later if you want. If there's lore you're curious about but missed, you can probably read or watch one of a bazillion things about it, as fans of this game love writing and talking about it.

The majority of people do not care unless you start going THE STORY SUCKED RIGHT GUYS I SKIPPED IT ALL or HAHA I DON'T KNOW WHAT'S HAPPENING THIS GAME IS TERRIBLE. In which case people would get mad, because FFXIV players are notoriously terrible at not taking bait, especially in these forums.