Yes, your sit bones is where most of your weight SHOULD be.
Look, I didn't ride all winter. Yesterday I finally got in a 20 mile ride to start the year off. Today my sitbones are really really sore. That's totally normal. As I get in another dozen rides or so the soreness will be all gone for the year and I'll ride several thousand miles with no sit bone pain and no soft tissue pain at all. I ride on a pretty hard unpadded Brooks leather saddle that is basically designed to support my weight on the sitbones.

If you are used to only being on padded cushy foam/gel seats and padded chairs, then your sitbones are going to hurt the first time you actually put all your weight on them...and they'll be plenty sore for days afterwards. But they'll adapt as you keep riding and then they likely won't hurt anymore. Having your weight on your sit bones prevents painful soft tissue pressure.

Riding on your soft tissue areas and not on your sitbones is very painful and can lead to nerve damage. But unlike your sitbones, your soft tissue cannot adapt to bearing weight, and will simply continue to hurt and/or become numb with nerve damage.