Technically, yes. However, the technique of the sissy squat makes it perfectly challenging on its own.
You may not need extra weights to make the movement sufficiently challenging, especially if you commit to using a full range of motion.