C.P.
My opinion is not based on science. And "your bad" is not a "bad" as you are just trying to follow the advice of the "experts." Think about it...your child is the "expert" of his own body and psyche.
If he wants a pacifier as something soothing at night, why not give it to him? The choice is mouth or psyche; your rest and your health vs a pacifier. He is only two. He obviously wants the comfort.
You are pregnant and need rest. Warm milk is soothing. I still have warm milk before I go to bed and I am "old." There will always be the nay-sayers who will quote the latest expert...there are multiple experts, just as there are multiple opinions. But in fact, no-one really knows. It is all about interpretation and opinion. He is of the opinion that he needs some sort of comfort. So why not just let him have that tool?
Believe me, there will always be battles to wage with your children, why make this one of them? This is not about a moral issue...it is just a parenting call.
We all want to make the perfect decision(s) for our children. The irony is- there is never a perfect decision. You can just do your best in each situation.
What is best here, in my opinion, is that you both minimize your stress. One day at a time.
The pacifier, or some other comfort substitute, may help him to feel relaxed in the morning so that he can stay in bed. I sense that this boy is becoming anxious. I believe that focusing on his anxiety will settle the issues.