By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT REGEXP_REPLACE(
'<h1 itemprop="name" class="zaglavie">Кофейное обертывание</h1> some text',
'<h1[^>]+>[a-zа-я[:space:][:digit:][:punct:]]+</h1>[[:space:]]*',
''
) text;
| text |
|---|
| some text |