Hi casv,
Welcome to Affinity Forums
Yes, this is a known issue when using the Apple (Core Image RAW) engine. If you switch to Serif Labs RAW engine it should open correctly as you stated.