So my cousin and her husband bought a house worth a total of 1 million three years ago with a net income of 6k. They were about the same age as you then. However, their equity was somewhat higher at 200k. None of the banks they approached had a problem financing 800k. They pay 3000 per month, and with that, the loan will even be paid off as planned in 25 years instead of the existing 35 years until retirement. Currently, my cousin is on parental leave, but that’s not a problem for them. Their family income is only 5300, but that’s enough for them. However, I’ve already learned here that this must be evaluated very subjectively. Some people can still save a lot with 2300€ without rent, and others can’t make ends meet with that. Of course, one would have to decide that beforehand before plunging into ruin. Normally, banks don’t really care about upcoming family planning in a caring way... By the way, my cousin doesn’t plan to work full-time, so that’s possible too.
What would personally bother me terribly, however, is that neither of them can be disabled or unemployed for a long time. Likewise, it would bother me a lot that I wouldn’t have the option to freely decide to maybe stay at home with the child for 2 or 3 years on parental leave. It’s also a difference whether you voluntarily get by with little money or whether you really CAN only spend little money for a long time.
So overall, I would also advise you to skip the granny flat and reduce the scope accordingly. But I fear there isn’t really much room to go lower. Our plot was similarly expensive to yours, and 1 million will not be enough for us with all ancillary costs and outdoor facilities... And if I were you, I wouldn’t be able to sleep peacefully anymore because you don’t know during construction if the cost won’t be 100k higher again :-(