I'll offer a different perspective than maybe what most people might think and also because of the age of our kids..so each person has a different situation.
My wife is a professional photographer who catches amazing memories for other families and for ours as well. I have the luxury of having every moment of my children's childhood documented in professional albums, etc.
Yet...when we go, she leaves her camera at home. A camera that is honestly an extension of her arm.
A lot of the reason is that we have 2 year old twins...managing a camera, switching lenses, getting the perfect shot while wrangling those 2 is impossible. But honestly before those 2 surprised us, she didn't bring it for either trip for our now 10 year old and now 7 year old.
See..the photo pass photographers aren't the best picture takers ever..but they do a good enough job. The trip is about being together as a family and some trips (like this one coming up), we are booking a family photo shoot.
But, through all of our trips, our family memory maker has been in most of the pictures with the kids.
And before the twins, when we all went on the Rockin Roller Coaster, there was no fear of the camera being hurt, dinged, scratched.
For us and for her, this is about vacation and being together and not having to worry about where did I put it, is the lens getting damaged, did I get the light right?
Do I personally believe that we could get that one or two shots that we would blow up and hang on our wall? Sure..maybe...but is that worth having to lug it around, risk it getting damaged, and having her not be in the shots?
Truthfully..think about how you will use these pictures? Are you going to keep them on your computer, post them to social media, send them to friends and family? You can do that with an iphone camera (the best camera is the one that's ALWAYS with you).
If you are going to create wall art to adorn your house with blown up mounted pics and canvases are create a fancy album that will go in your family archives, then maybe a DSLR is the right camera to take.
Think about your priorities, the use of your pictures, the importance of your presence in family memory pictures. Then decide.
In 10 trips including our wedding trip, she has never regretted not having it.
But each person is different so just look at what is right for you.