I think some clarity that has been missing to your point is that this isn't an issue that Affinity can't edit raw photos, but more that if you switched from Lightroom to Affinity you're going to be missing all your edits for all your photos, which makes it a non-starter for anyone who doesn't want to or can't redit all of their RAW files.