Sakura still have decent amount of Fanbase and most of them are comprise of the sellout from Sasuke fans which has all to do with the Pairing. Even if Boruto series is giving a central focus on the Hyuga, the sakura fans will likely never die out because they will cling onto Sarada who is apart of the Main Cast as a way to justify Sakura.Sakura already lost half her small fanbase with chap 700, and then more with Gaiden. Hopefully, they will soon all die out.
The only way where the sakura fandom going to completely collapse is if Karin was the real mother of Sarada, which honestly I doubted because Kishi couldn't bring himself to do it when there are large margin of SS fans in japan and there will be huge outrages if that happen which will be on the declining.
In regards to Hinata, I don't think titles alone like the Byakugan Princess will be enough to cause Sakura fans to stirred up in the negative light. If Hinata receives a better treatment where she plays huge significant role with the Ootsutski and have atleast beat a strong formidable opponent in VS Matches then its likely Sakura fans will be insecure and they probably can't stomach it any more. After that happen, they will move on to different fanbase and probably clutches over Hanabi as a way to pitted against hinata with their intention to cause the hyuga fandom to stirred up.
However, I don't think Hinata will play important factor anytime soon, maybe in the long run but the only thing left for her currently is the fight against Momo and even then we know the outcome that she lost and even if she performed well and make somewhat a contribution, I don't think that will impress the others. Hinata has to win to make a clear apparent in order to get Sakura fans through their thick skulls.