It depends! Pressure can feel comforting to me depending on the context; I love when my cat is laying on me, or cuddling up with my partner. But when it comes to sleeping, I don't really like pressure on me, just feels too restrictive.
I've tried a weighted blanket that my friend has for anxiety - and it was too much for me, I almost throughout the year just have the cover without the duvet itself, just so I have some kind of cover.
It doesn't also help that I sweat abnormally so I have to be careful to end up into a puddle in my sleep
It’s actually much more comfortable for two people in one bed to have separate blankets. :) might be worth trying two twin blankets. Then your partner could have what they prefer and you could have weighted.
My wife and I started sleeping with separate blankets a while ago. I like to sleep with 2 heavy comforters even in the summer but my wife gets hot while she sleeps. A lot of the times we end up sharing a single blanket by morning but I don't think I could fall asleep like that.
Also I just realized while typing this that I do like weight on my body!