Same experience here with Affinity Photo. That is a bit frustrating.
Let's take my scanning routine for my example. I scan an image in 600DPI and open it in Affinity Photo for corrections and resize. It doesn't matter if I change the document into centimeters, change DPI and size and then export it to a Tiff. The next time when I open the image it's back to pixels and also back to the initial DPI (while the pixel dimensions remain).
1. Initial scanned image opened in AP:
5100 x 7019 px
Pixel
600 DPI
2. Change document settings into:
21,59 x 29,71 cm
Centimeters
300 DPI
3. Export the file to Tiff
4. Open the Tiff file and check document settings in AP or Photoshop:
2550 x 3510 px
Pixel
600 DPI
That's very frustrating and not very functional as it's not possible to export an image with the dimensions that I would like to define. That make a workflow a bit difficult if I send out files to clients, printers or colleagues. The resolution remain, you don't loose quality, I know, but the output size is simply different than it supposed to be. Let's say an image is printed on a T-Shirt then the size of the print would be wrong.
Anything that I'm doing wrong? If not, I would hope that this is going to be fixed or updated.