We love 5e 2024 changing barely anything but charging us 80$ + 20 for digital

We should have foreseen that.

That's the problem with making perfect products. Once everyone has it, you don't make any money. So you change like 2 things and force everyone to buy it again or go out of business. I'd make a foresight joke, but am late to that, lol.

This spell sucks.

at the super very least it should be a 7th level ritual spell. Then it might get used by a dnd table. 

I disagree. This spell is great to cast at the tail end on a Long Rest. Spend one more hour resting, and for the following 7-ish hours you reap the benefits while toting around a fresh 9th-level slot.

The above, plus 9th-level conjure minor elementals and 8th-level Jim's magic missile is pretty crazy; for those sticking to the 2024 PHB, 8th-level scorching ray also works.

Casting any spell other than a cantrip disrupts a long rest

Quote from SpringPurse >>

Casting any spell other than a cantrip disrupts a long rest

 Yes it does, which is why it takes an additional hour to complete the Long Rest; about 7 effective hours instead of the spell's full 8. We can push this farther by using the Metamagic Adept feat from TCoE to get Extended Spell, effectively getting an extra 9th-level slot's worth of duration AND having all of your resources available.

For my money, this is the most consistently powerful level 9 spell in the game. It lasts a full adventuring day, it protec and attac, no concentration, and is strong enough that you feel it but not in a way that forces the DM to counter it while designing fights. That last bit being very important; if an effect is too powerful, DM can't just ignore it and you're going to get dispelled or incapacitated in order for the entire encounter to not break (Invulnerability...). This is right on the cusp where a (good) DM will err on the side of not trivializing your single level 9 spell for the day because it feels terrible for the player. Perfect levels of power (but can be broken with Extended Spell shenanigans as mentioned above).

Rexir2 is exploiting. Ignore them.