New pyrazole‐4‐carbothioamide‐based metal complexes: Synthesis, spectral characterization, computational, antimicrobial, and antitumor investigations