I'm also a rotational player. So far I've adjusted well but I'm playing in spring, so weather isn't too severe. I've decided that the 28 day length does work for me because I really like dragging each season out. It feels more realistic to me and I notice subtleties in the weather every day.
For my own play, I've just decided that I will not follow an exact timeline for when I play each household. I'll just play them when I want to and they will get to experience whatever the weather is at the time that I'm playing. Because I move between the different worlds, I'm experiencing a lot of different weather. I will admit that when I send sims to visit another world, I have no idea what the weather will be like there. It is kind of fun and also kind of an adjustment.
Weather is basically just another layer in my game but it does impact it a lot. I haven't done too many holidays yet but so far I've found that I just need to decide what household I am playing for a given holiday. None of them are aging unless I say so, so I will eventually repeat holidays with different families.
I've decided that I'll just add new holidays for a given household while I'm playing it and then I'll delete holidays if I switch houses and they aren't appropriate for it. Basically, it's all just another thing that I adjust. I don't think I'll be shortening the seasons with a large rotation though. If I play another save with just one household, I'd probably make each season 14 days. 7 just feels too short for me personally.