Dear OP, I am sure you and your DH are happy and might stay happy for a long time.
But I want to tell you about very different experiences of me and my DH and how we look at it now.
I come from a line of working mothers: my maternal grandmother was the first one (and the only one) of her family to go into higher education (which has resulted into being the first one to get a professional career). My paternal grandmother lost her husband in a Soviet concentration camp and upon returning home had to train herself and get a job, so she could support herself and her two children (both of whom went onto studying in universities and being successful in their careers).
As a result, both of my parents worked full time since I was few months old. I remember few occasions when I felt sad that my parents could not attend my school concerts during the day, but I don't remember thinking that my parents did not love me. I did not got a day without a hot meal and we had family breakfast instead of family dinners (as my parents used to work until very late hours and I was asleep by the time they used to get home).
My DMIL has worked before she got married to my DFIL and had lovely career prospects in the future, but gave it all up to stay at home with children. It was her own decision, which was fully supported by DFIL. My DH says that when he was a child he enjoyed her being a SAHM, but as he and his siblings got older they just did not find time spent with her very interesting as they would have very little to talk about.
DMIL has recently started working again (after ~20 years of being a SAHM), but was not able to get a similar type of job that she was good at, as the type of job that she was doing has been greatly computerised. And if you want to do this type of job now you need a lot of knowledge, training and specialist qualifications. At the moment she is doing unqualified work that she enjoys, but there is no prospect of furthering her career or getting a pay rise. DPIL are still happily married, but I sometimes feel really sad for my MIL as she hasn't got many friends and her children don't talk to her very often.
I can't force my DH (and his siblings) to talk to his mother more often, but he feels that they have very little to talk about. On the other hand he likes talking to my DM, who works ~50 hour a week, travels to conferences, attend courses, seminars, belongs to various professional bodies and does other job related things. They spend hours talking about politics, law, job prospects, conferences and other things, even though we all do completely different jobs. It is like learning from each other.
You know, OP, job does not only bring you financial security, but also broader understanding of the world, meeting new interesting people, learning about politics, law and economics, and other intellectual things. I am not saying that SAHM have no interests. They do. My DMIL reads a lot and you can discuss some books with her, but its impossible to discuss any professional literature (of any sorts) with her, as she only reads fiction.
I truly hope that your kinds would not find you boring when they get older, as I can see how upsetting this is for my DMIL.