The Danish monarchy is over 1000 years old, but the English and Japanese monarchies are older. These rulers have had the sense to move with the times, which has mostly meant assuming a symbolic role and delegating actual power to elected officials. Their resilience has been remarkable. Nevertheless monarchies will eventually die out, as people will resent the amount of taxpayers' money that keeps them in luxury.
If royal families don't actually rule the country, they shouldn't exist. They're just a distraction from more important things, like how the country is actually governed. I would be very angry if my country had a royal family, especially if it was funded by taxpayer money. If you don't provide any value to the country, you shouldn't get taxpayer money.
Yes, monarchies are destined to die out because the world is changing quickly. There is no way a family will be able to continue its line for thousands of years because something could happen to the descendants. Maybe someone will not be able to have children, which will end the family line.
The first King of a United Scotland was King Kenneth MacAlpin who died in 858 AD which is 100 years before the death of Gorm the Old who was the first King of a United Denmark and 69 years before the English monarchy was founded. So Scotland is the oldest.
The Danish royal family, in a similar way to the institution of the monarchy in Spain and the United Kingdom, are fairly popular in their country of origin. While the monarchy as an absolute vestige of power is never likely to return to Europe, the token royal family as a reminder of the heritage of the nation is something many populations would be loathe to be rid of.