You put together an awesome list! I picked out a few things that caught my eye...
1. Upstairs of the school (classes rabbit hole ): My guess is no it will be active just like the first floor. You'll be late to class constantly because of bottlenecks on the stairs though.
2. Need A rug/mat for cheerleading can’t just cheer at any place at any time…YOU WILL NEED THAT RUG OR MAT: It will be tied to some object in the same way that the hangout feature in werewolves is tied to the pack hangouts.
3. You may have new lockers but only one locker out of the row will be functional And will be somewhat of a rabbit hole type of gameplay: There will be limits but I don't think it will be just one, maybe two or three per set.
4.You can woohoo on the Ferris-wheel like you do with Leaf piles and bushes the riding part will be a rabbit hole. you can’t see yourself up there at all: I think it's already been confirmed that the Ferris wheel is a rabbit hole.
5. The haunted house will be a rabbit hole just like the Sims 3.: Yeah, I can't see that being active, sadly.
6.Only one special window from build buy will be functional for sneaking out not all windows will be updated with this feature. Agreed. Again there is a parallel to werewolves with the werewolf only door, this would be something similar
7. You cannot raise the window to get fresh air it’s only functional for sneaking out or sneaking in and I believe that will only be limited during certain times of the day or night I'm hoping that's something we could at least do with the window for sneaking, but if you can open them it will only be with windows from this pack so hopefully they have a more universal styling that can work in a lot of different building aesthetics.
10. Football and or basketball games will be rabbit hole just like university it will give you times you can attend/practice but you will not actually see any Sim team members playing the game on the field. Basketball and soccer don't really have any animations that would lend themselves to team play, and there's not much you can do with football in this game aside from maybe playing catch or kicking it, so sadly they will be rabbit holes.
12. The carnival area will be the same as the city living events (venders,live music ect..) As I stated before all rides/activities will be rabbit holes. (We may be asked questions to answer like we do at work) That's a really good comparison. Hopefully there will be lots of new activities there and not just a recycling of the things at the festivals in San Myshuno.
13 A little update will be added for cell phones far as texting or social media but not as overwhelmingly exciting as seen in video. Like others have mentioned I'm worried about the social media function becoming as intrusive as the phone calls we deal with now.
14. The prom will have some limitations on decorating I believe you may have a chance to decorate but not as hands on as we may think. I hope we get lots of options for really decorating the place up in a variety of themes. And I hope we can create our own themes too.
15. Graduation Will be half rabbit hole half gameplay (??) I think it will be all active/visible but it won't have a lot of depth or interaction. Then again they did make mention of Valedictorians so there should be some sort of option for making a speech or something. Maybe that's the one active element, if your sim is the Valedictorian she/he can make sort of speech with a few options you can choose from.