You are a Novice Driver. You fall under the Escalating Sanctions program. Your license will be suspended 30 days upon conviction for your BAC above 0 charge.
Insurance wise, you're looking at getting booted. BAC above zero for a G2 driver is usually treated the same as a fully licensed drunk driver. No difference, serious offense, 100% increase if they don't decide to cut you loose.
They might decide to help you out with the other tickets, but those are small potatoes compared to the drinking charge.
If I'm on someone else's insurance as a secondary driver, it won't affect their prices for themselves once I'm booted off right? Just my own wherever I go (which I understand I likely will not even be accepted on new insurance even at a super high premium).
If you live in their house, you have to be listed on their policy. If you want to be removed, you have to fill out an exclusion form. It's a form saying you won't drive their cars.
After that, their premiums would return to normal.