The 54-year-old Wuthering Height's singer was awarded a CBE for services to music in a ceremony with The Queen at Windsor Castle