when zidane was coach of real madrid he also started to suffer the same problem: lack of goals. so zidane left, but as the team managed to win la liga and the champions league everything was fine, but if we pay close attention we will see that real madrid only won la liga last season because barcelona is going through troubled times, this season season barcelona are much better than last season real madrid has no chance of winning la liga
Zidane did saw that Real Madrid had issues with their squad and he knew that it's safer for his reputation and his career by leaving Real Madrid. Years later, Real Madrid still managed to win La Liga and Champions League with nearly a same squad. Their old players did successfully prolonged their career and even won titles with Real Madrid. However it does not change a fact that they need to have more new and young players. I believe they did saw the issue and they bought Rodrygo, Vini, Valverde, Camavinga and Tchouameni to gradually help them to adapt in Real Madrid then replace old players.
They even tried to buy Mbappe but failed when PSG gave him a very crazy offer.
going to the problem of goals, real madrid only depends on benzema, which means that when benzema is not doing well in a game, then real madrid will not be doing well either, vinicius is an excellent player, but he is not a player who scores goals regularly, his role on the field most of the time is to open the way for Benzema to score a goal, rodrygo the same thing, apart from those 3 the others do not have a good performance in the team. real madrid needs to sell the strikers that don't bring goals, and hire the ones that bring goals
Maybe Real Madrid will return to Mbappe or Haaland in next summer especially with Mbappe. Haaland looks to be happy in Manchester City but Mbappe does not have same feeling in Paris. Benzema is a very good striker and he scored many goals for them in this season even his contribution is limited by some injuries. Though he can play well when his body is ready, Real Madrid should not rely on Benzema in a next season as his body might become more sensitive with injuries.