Nah, game is not really in trouble. I hate the direction some of the content has gone - EW relics, EW alliance raids, what IS turned out to be, healer (lack of) design, pvp balance, the intensification of solo play in an mmo, the EW Blue Mage lack of actual content update that had Blue relevant for a few weeks and then died out again, the godawful patch story.
I'm not going to cancel my sub over it. And if there's something on the shop I want to buy, I'll buy it.
I don't have anything in particular against Yoshida. But his time has probably come. Put in a succession plan or something. Though, based on patch performance, it's not like the other staff really carried the load while he was off on his FFXVI adventure. I always hated the argument of "if you don't like it, unsub". But I will unsub when I don't like it. Or, probably more accurately, when enough people I know stop logging in.