It's entirely up to you, but I'd personally be wary of getting a quartz movement (with 3-4 years battery life) as a fairly expensive watch intended to be passed down in many years time. If you want to wear it a lot and pass it down to your son, I'd probably go for an automatic.
You could look for "second hand" watches on sites like chrono24 or ebay - the watch you linked can be bought for around 600 including shipping on there at the moment in basically perfect unworn condition although the battery life will change depending on how old it is. Obviously make sure you check out the seller first to make sure they're legit, but as long as they're not 0 feedback and sending from China you're gonna be fine.
You could also opt for watches like:
https://www.chrono24.co.uk/frederiqueconstant/fc-330mc4p6-classic-auto-moonphase-watch--id5717446.htm https://www.chrono24.co.uk/frederiqueconstant/classic-moonphase-new-official-warranty--id4346704.htm https://www.chrono24.co.uk/frederiqueconstant/classics-moonphase-fc-715mc4h4--id6834786.htm https://www.chrono24.co.uk/frederiqueconstant/classic-moonphase-335mc4p6b2-original-box--id8554143.htm
They are all very similar watches and at a comparable price, with the only difference being they're automatic.
You can also use the search feature of chrono24 to find watches with the exact features you want, like this: