I am attempting to retrieve the HTML Rich Text field "Content" from ContentNote object, but results are not rich text. The closest I can get is the following query:
Select TextPreview, Content from ContentNote where id = '069...'
TextPreview gives me the text, but not HTML. Content gives me an alphanumeric coded field, but not rich text.

What I need is the actual text with HTML codes like a rich text field. What field/object can I query to retrieve the rich text from the content note object? If I can't, is there a trigger I can write to migrate that value on another object that I can query with rich text?