This GeoNet page from 2011 states:
Oracle Express is supported with ArcSDE 10 for non-production use
However, this information is old, and I don't have ArcGIS Server/ArcSDE. It's still unclear whether ArcGIS Desktop Advanced (Personal Use license) would be able to create a geodatabase in Oracle XE or add the st_geometry user-defined type.