I have replied to many of the threads on sex. There is so much great advice on here so please look at all the threads. I won't address your desire to have more children as I think that has been addressed effectively in other posts.
My sex life has got more intense and wonderful in the past two years since I was first diagnosed in March 2024. I had the operation and had the version known as 'non-nerve sparing', in short this means I will never have a natural erection again (less than a 10% chance). Together with my wife we have found many ways round this including using a hollow dildo on a strap, using vacuum penis pump and ring to hold the erection, and we did try a self injection into my penis but for various reasons that didn't work for us. Much of our love making involves mutual masturbation when we don't want to spoil the flow of the moment. In short your sex life is not over and this could be the start of a new adventure!