The other is that is there a particular reason you are leaving the money for your kids. It is generally accepted that when kids are left with large sums there can be some serious negative effects on their life. Notice how bill gates and warren buffet is handling it. Just saying you may want to think about that (i also realize its non on my business and is not the question you asked).
There is one investment most people make with a 25yrs commitment and that is real estate. For the most part (for this kinds of timeline) it has proved very resilient, even despite the 2008 financial crisis.
lastly, you might want to set up a trust. This has several benefits, such as protecting the money from things like lawsuits and fighting for who gets what once you pass. Most people think their kids will get along once they are gone but with large sums things are often different. Also depending on how you structure it, it may help with taxes.
Im my experience, a great CFP is someone who will work with you to come up with a plan and help you successfully execute it. That means protecting you from emotional rather than rational decisions and making changes to the plan as circumstances change.
This kind of planning requires coordination between your lawyer (estate planning), CFP, family members etc to pull off successfully. Its quite the undertaking. Good luck!