Toddler sleep regression

How long does it usually last?? My son will be 2 next month but for the past few months, he started regressing and it’s only getting worse. We’re lucky if he sleeps through the night now. Tonight has been one of the worst. He’s not sick or in pain. He just is refusing to sleep and throwing the biggest tantrums all night screaming and crying no matter what we do. My husband is pissing me off too looking at me saying oh “it’s a learned behavior” like wtf you trying to accuse me?! He is another story ugh. How is this a learned behavior?! Doesn’t even make any sense. This is normal toddler sleep regression. How do I handle this? When he gets hysterical, we always take turns going in and soothing him back to sleep except tonight not even that’s working. He wants to play and be picked up. Do we need to just ignore him when he wakes at night like this? He has no problem when we put him to bed, but he will wake an hour or two later and continuously wake throughout the night. Sometimes he has night terrors but lately that hasn’t been the problem. He has a very consistent bedtime routine as well. I’m just so tired and our baby girl is due in 8 weeks idk what I’m going to do. Currently 3:53am here and I haven’t gotten any sleep. 😓😭😫