The widespread technique to deal with these units is to strip everything after the first space before parsing into a float:
=Number.parseFloat(items.AqaraMQ_THPS3_TEMP.state.split(' ')[0])
I plan to add some utils functions in the expression scope to deal with this and other cases.