I think it will continue to drop, but still get some use, as classic names always do.
I don't think it's boring - it's never been a special favourite of mine, but it's a perfectly good name. I prefer
Catrin to the English versions, and
Catherine from those.
Pronounced with two syllables I don't think it needs an nn, but if I had to pick one, then Cat.