Question: are the sith extinct after rise of skywalker?
Answer: As it stands, they are gone. There are, however, Sith holocrons all over the galaxy unlike the Jedi holocrons, which were mainly destroyed. For the Sith to rise again it would require a Force-sensitive, probably already with some amount of training, finding one of those Holocrons.