Now I’m wondering whether I should just put everything pre-2026 into an ‘Archive’ category and just start afresh from this year…

A though just occurred – part of the reason why the categories are in a mess is probably because tags didn’t exist in WordPress until 2007, so multiple categories on posts was a regular thing in the early days.