The Norwegian Kings has always been at their most popular when they have one foot in the grave

(the amount of love he and Sverre Magnus got at the soccer game in the social media was impressive) but before he was king, Harald was seen as grey and boring without the war history of his father, he was not a great speaker, and Sonja as uptight and a big spender and not very natural with an extreme posh Oslo dialect that no normal people have. She still has it, but she is not so concerned with beeing perfect anymore and laughs more, users less hair spray

and seems therefor more friendly and relaxed. And I think people now have more respect for the what she has done, especially for art and culture, and the fights she has fought silently, so beeing Perfect is not really a core quality for the Norwegian royals I would say.
No doubt the court case will be a media show and affect the popularity of the family in general, and Mette-Marit especially, and she has already suffered in the polls, with good reason, and is now way behind the rest.
But in general Norwegians have rather short memory when it comes to the royals, but I think there is also a general trend with the younger people that they question inherited power in 2025, but then most politicians are unpopular and some do stupid greedy things that reflect badly in the rest, and then we settle again for the King who everyone likes anyway. But of course people like the fantastic presidents of Finland and Iceland does show there are very good nordic options that has nothing to do with a power-president like the US, and if we started to compared on pure merit to someone like Mr Stubb, all the scandinavian royals would come out way behind and then some.