Use CMS fields in embeded custom code inside rich text field in collection Item

Yes this is not supported. As to workarounds; that depends on what you are trying to do. If you have field values present in the DOM (maybe even hidden) you could grab them and act upon them with custom code.