I would never say that Xavi has completely failed at managing his players so far. Barcelona have shown significant improvement under him, but losing several key players in the same season is very difficult. The financial crisis experienced by Barcelona has certainly slowed down Xavi in building his best squad, but if Xavi and management can be patient, then the academy players who are currently carrying heavy responsibilities will prove their quality.
At least, Xavi ever won 2 trophies in the previous season. He won La Liga trophy and Spanish Super Cup in the season 2022-2023. It is wrong if we jduge Xavi totally failed managing Barcelona. He already proved it with 2 trophies.

If Xavi failed to win any trophy in this season, it is because Barcelona doesn't have a competitive squad. Lewandowski is decreasing his performance and he got injured for a long time, Barcelona has no good defenders, and Ter Stegen also got injured for many months. This really bring big impacts to the performance of Barcelona, they have bad attacking and bad defense. Xavi actually needs new strikers and defenders to deal with this problem, but Barcelona has no money to buy proper players. Because of the financial crisis, Xavi can't solve the problem on Barcelona team.
With those problems, they are lucky that Xavi still lead Barcelona to finish as a runner up this season.
I agree with your statement, Xavi has never failed miserably for Barcelona. He worked hard and he proved it well, but things have changed and today I was really surprised when I saw the official announcement on the official Barcelona website.
Xavi's sacking really shocked me, it's obviously very ridiculous because I never wanted it. This is a bad decision from Joan Laporta, in my opinion.
Xavi not to continue as FC Barcelona first team coach
In a meeting at the Ciutat Esportiva Joan Gamper, president Joan Laporta has informed Xavi Hernández that he will not be continuing as FC Barcelona coach in the 2024-25 season
Today Friday, FC Barcelona president Joan Laporta has informed Xavi Hernández that he will not be continuing as first team coach in the 2024-25 season.
The meeting happened at the Ciutat Esportiva Joan Gamper and was also attended by sporting vice-president Rafa Yuste, director of sport Anderson Luís de Souza, Deco, Xavi, Òscar Hernández and Sergio Alegre.
FC Barcelona wishes to thank Xavi for his work as coach, as well as for his inimitable career as a player and as team captain, and wishes him every future success in the world.
Xavi Hernández will be coaching the team for the last time in Sunday's game away to Sevilla.
During the course of the next few days, FC Barcelona will be making an announcement regarding the new first team structure.
Several main players may be sold by Barcelona in the upcoming transfer market, and even several players who are currently on loan are expected to be made permanent by the team that uses their services. Eric García, Ansu Fati and several other players may be made permanent by the team that provides them at the moment, but it is not known what Barcelona wants.
To have the funds, Barcelona may put some players on the transfer list. However, I don't know if it can give enough money to buy new players. Barcelona also has limited players, and most of them are young players from their academy. So, Barcelona has no many options for selling players. Anyway, I assume Xavi may plan to bring back Eric García and Ansu Fati to the main team. These players have performed well in this season, they will be good addition for the team.
Plans may have changed after Xavi was officially fired. Now everything really depends on who the prospective coach will coach Barcelona next season. I know Ansu Fati and Eric Garcia are good, but I'm not sure they'll be expected to come back and stay.