Dear Shaun,
Thank you very much for the help. I am not sure whether it was the console command or updating Unreal 5.4 with the new hotfix, but the water rendering works now!
Kind regards.
UPDATE: It was the command that fixed it; by default the water is still missing, so if anyone has trouble, make sure to add r.water.waterinfo.rendermethod 2 to your render commands.
