I see Gareth Bale happier playing for Tottenham, since on loan from Real Madrid Bale's performance was very good when he played at Tottenham.
But it looks like Bale wants to respect his contract with Real Madrid with one year remaining, so according to the latest news I read, Bale will play
for Madrid next season. Hopefully new Madrid coach Ancelotti will give Bale more playing time.
In Tottenham, Bale plays very well, so one cannot say that he has no desire, just Zidane gave him little playing time. In Real Madrid, the issue with the strikers has not been resolved, I would say that there is no strong striker who would sit firmly at the base, maybe except Benzema. Since Ronaldo left the team, there is no equal replacement for him.
Real Madrid really need a top striker now. After Ronaldo they've lost a lot of power for sure. As far as I know, they have been after Mbappe and Kane to solve this problem. But PSG don't seem like they will let Mbappe go at least for now. There are many big clubs that want to sign Kane also. Real Madrid's job won't be easy especially against Manchester City.