Depends. It can be impossible or very easy. If its always the word CHAPTER, tats easy, and i guess you woudn't have asked
If all letters are capital you can just search for ([A-Z])_ and reaplce it with \1. The probality that a capital letter is followed by a blank is low, but not 0. So yo have to go through the text one at a time to make a decision.
In any other case i would assume its not possible as Regex in sigil cant be limited to work only inside a specific element (AFAIR Calibre can do that) So you are catching too many wrong positives if your heading is mixed-case.