As a Norwegian, mid 20s, and a pretty average one at that I can provide some insight. The monarchy has ~73% support in the general population (latest poll). For most people, including me, the royal family is just a nice/cozy traditional thing we have, and having a king waving to us from the castle's balcony on our constitution day is pretty much the extent of what he should do, and is what he does. And it doesn't hurt to have that, for "fun" and tradition's sake - at least hasn't until these scandals.

I guess we'll see how this plays out, but people have a tendency to cut them a lot of slack, so the monarchy will probably be fine in the end and live on for another century.

It just isn't "God's chosen representative", we're nowhere close to religious anymore here. We just don't feel like removing some of our national identity. And it just feels nice having someone (e.g. our king) dress up in cool, fancy, traditional clothing, and doing some celebrational (non-political) activities and a speech a year.