Can Rift Herald force my opponent to play a unit from hand?

No. A player cannot be compelled to perform an action on private or secret cards if the effect specifies a type or quality of card. They may ignore that instruction instead.