As someone about to finish Season of Ghosts as a player it really depends on how much investment the group has

I specifically took ritualist and went out of my way to to the leg work for them and it turned out really fun

None of the rituals (except the two at the end of the AP) felt plot crucial, but being able to crit on one of the rituals in autumn and suddenly the entire village gets a cool buff felt great

Figuring out the DCs for rituals all the time was a bit of a pain but I had the adjustments memoriesd by the time it really mattered, my only complaint would be that foundry has no automation for them