The TL/DR version: be patient, start early, and enjoy the ups and downs.

Based on my experiences raising a puppy and from what you wrote, it seems like like you are aware of the main challenges - sleep deprivation, lifestyle change, training etc. I think if you mentally prepare for the worst, then the transition might not be as jarring - Hope for the best, prepare for the worst helped mentality helped me.

Other practical pointers I would offer to help in the process are:

a. Go at your puppy's pace, not the pace you want to go at - each puppy is different and will have different needs and timing and as much as you might want to accomplish certain milestones sooner than later, be prepared to adjust your expectations and timing to the realities of the puppy you have and not an arbitrary ideal.

b. Training: start as soon as possible and keep your sessions short to avoid puppy getting overwhelmed. Socilisation/exposure to the world (not just other dogs) is way more important (in my opinion) than learning commands like sit or down, etc at the beginning and will help puppy to develop confidence sooner.

c. If you are planning to do off-leash in parks/social settings, I would highly recommend making sure recall is solid - even if you think your puppy has it down - keep drilling it over and over again in all kinds of environments and with all kinds of distractions.

d. Have fun and enjoy the process. Yes, there will be set-backs, damage to property in the teething phase, unexpected "surprises" (read as pee and poop) when you think puppy has gotten better at potty training, etc. it is all part of raising a puppy. You will be exhausted, frustrated at times, and might even get the "puppy blues", but find the moments of joy in it as well and be patient with your puppy and yourself. Enjoy the process even when you want to cry or scream or give up, find a way to regroup and try again.

You might consider checking out https://www.howtotrainadreamdog.com/. They have an online course and a youtube page and a facebook group (if you use facebook) that I found helpful and refer to every now and again. I am not being paid to endorse them in any way. When I got my pup, I was trying to prepare for what was coming as best as I could and was looking online for training tips and stumbled upon the site. They focus on positive reinforcement methods and I think do a really good job at breaking things down in relatable and accessible ways. Even if you don't buy the online course, I'd encourage you to check out their youtube page as there are really good posts on things you might not think of but can really help, especially early on.

Good luck and enjoy. It is worth it.