Confirmed no points changes on Rubrics and Scarab Occult other than the Sorcerers becoming regular members of the squad and thus not paying a tax (the change was already made for Rubrics in the Chaos Space Marine codex) is a bit of a bummer as I'd say Rubrics could use a 1-2 point drop and Scarabs either need a bit of a rework (i.e. 4+ invulnerable save stock increasing to 3++ with either Weaver of Fates or All is Dust) or a slightly bigger points drop. However, I find Rubrics are already very close to the sweet spot for points anyway and that Deep Strike stratagem + teleport Relic massively change the complexion of the unit as it is. Ultimately the big change both units needed was the addition of actual spell selection and that is what we've gotten, meaning our formerly terrible tax squad leaders are now useful again.
Our auras becoming more in-line with Chaos Space Marines makes sense, we've lost a little bit of durability (a lot in the case of Magnus or anything that could get to a 3++ reliably, i.e. Ahriman) though it bears mentioning that our Daemon units get 6++ from the Changeling, and Glamour of Tzeentch's -1 to-hit coupled with Temporal Manipulation's D3-wounds heal do offset it a bit as well. Our offensive punch increased by a lot thanks both to our squad leaders getting powers, our army as a whole getting more powers to play with (including auxiliary Tzeentch Daemons) and those sweet re-roll 1s to-hit auras. Previously Magnus would rarely stick with a Thousand Sons gunline meaning our only real offensive buffs were Prescience and a borrowed Veterans of the Long War from a Chaos Space Marine detachment. Now, we don't even need Magnus for re-roll 1s to-hit and we have Veterans of the Long War in-codex, so no need to break theme with a Chaos Space Marines detachment if you don't want them (however, Alpha Legion Cultists in general still look to be better than ours, and whether we have Tide of Traitors or not could make a big difference)
Overall, while I would've been happy with some points drops here or there, we're still going to be in a way better spot than we were. Rubrics get elevated so darned much from Deep Strike capabilities, they are legitimately a really scary alpha strike unit given all the buffs we can put on them, and ditto Tzaangors for tying stuff up in combat. Our psychic phase with or without Magnus is improved by virtue of having more actual psykers and more powers to choose from, and generally speaking the re-roll 1s to-hit auras on Ahriman and Exalted are a godsend. Finally, we have a damned good Legion trait even if it is only a one-part rule that specifically affects psykers alone. Those extra ranges make our foot-sloggers less of a tax, our disk-riders and teleporters more frightening and generally give us a lot of flexibility. Staying out of deny range and still being able to cast offensive powers (enemy psykers rarely sit on the front-line) makes us more likely to actually accomplish stuff in the psychic phase, and the increased range of Warptime alone is incredible. Our character sniping capabilities in conjunction with one or two Tzeentch Daemon wizards (or just a Thousand Sons Daemon Prince) are really strong provided we have a few different ways to improve casting rolls.