How important is GPU core/mem clock frequencies compared to VRAM size in UE5?

exactly. you can use it during development. but the average consumer stat should be taken into account. steam hardware stats are a very good helper there. for console deployment the limit for vram is 10-12 GB, depending how you balance cpu and gpu workloads.