No. While mild discomfort is expected and varies based on the individual stretch, significant discomfort or pain doesn’t mean the stretch is “working better.”
In fact, it may even be detrimental. Since the physical mechanism of stretching involves relaxation of the nervous system — not physically lengthening the tissues — an intensely uncomfortable stretch may actually cause you to reflexively tighten up further. (6)