The 'level of personal affront' may well be because the royal family have been a constant in our lives, like them or not; Governments come and go, celebrities, personalities, stars flourish then disappear, natural disasters shake lives, but the royal family, being like all families, always has occasions which reflect our own lives.
I remember the Coronation vividly, someone yesterday recalled the Queen's wedding fondly, (didn't know she was that old),every one remembers where they were when Diana died, and most will remember the fall out from this latest soap opera drama.
Births, marriages, deaths and everything in between.