EXPO is akin to Intel's XMP. The RAM stick reports timings and other settings that it can handle and then the motherboard/user selects one to use. The profiles are needed because the official JEDEC standard for DDR doesn't provide a mechanism for running up to the frequencies that modern RAM uses; e.g. if you buy a DDR5 6000MHz kit, it'll only run at 4800MHz or thereabouts until you enable EXPO/XMP. RAM is really never expected to be run at the base frequency (without EXPO/XMP). If you buy a prebuilt, it'll have EXPO/XMP enabled, and if you build yourself you always should be enabling it. If you have a RAM kit that's somewhat recent and don't have it enabled, you've likely wasted money on the RAM.
Intel has attempted to claim that XMP was overclocking and violated their warranty but my understanding is that they quickly backed off.