VOICELESS GLOTTAL FRICATIVE [h]
Tiberian Hebrew he is pronounced similarly to English "h". Note, however, that at the end of the syllable, pronouncing an "h" sound is not very typical in English. This is what is intended when he is written with a shewa under it following a vowel (i.e., הְ). You may have to work a bit harder to pronounce "h" at the end of a syllable. Because of this, even the Tiberians sometimes inserted a helping vowel so the "h" was not at the absolute end of a syllable.
WORD-FINAL VOICELESS GLOTTAL FRICATIVE [h#]
When he is written at the end of a word, it typically marks a vowel (e.g., [aː] or [ɔː]). However, when it is written with a dot inside, i.e., mappeq/mappiq, this is an indication that it should be pronounced as consonant closing the syllable. The mappeq/mappiq is not to be confused with dagesh, which actually indicates that a letter should be held for extra length. In some manuscripts, mappeq/mappiq is sometimes even marked on he in the middle of a word. In such cases, he should be pronounced just like he with shewa closing a syllable (see above). Note, however, that when word-internal he is written without a shewa or a mappeq/mappiq, it should not be pronounced (as in פְּדָהצֽוּר).
SOURCES AND FURTHER READING
Khan, Geoffrey. 2020. The Tiberian Pronunciation Tradition of Biblical Hebrew. Cambridge: Cambridge and Open Book Publishers. §I.1.5.