Going off a very quick twitter peruse, it’s a mix. Some fans aren’t happy while others are like “meh. She earned her retirement in the last one”
I always thought that Sidney should've had her swan song in Scream 4 but since they didn't do that I considered how they set up her idyllic life in Scream 5 with the husband and kids as a good way to let her ride off into the sunset and live happily ever after.
But it is more trouble than its worth to try to shoehorn Sidney into any new Scream movies because there are only two options to do it:
1. Gayle is killed by the new Ghostface and Sidney shows up to avenge her homie which is basically just redoing how they got her involved in Scream 4
2. Have some random Gen Z weirdo decide to put on the Ghostface mask and target a middle-aged wife+mother for "reasons".
So they need to let Sidney go and focus on the new class of characters with Gayle involved because her job in the media makes her automatically tied to any story involving a Ghostface killer.