Hi Leo,
Not sure if you ever solved this one, but I've been having issues getting a local elevation to work as well. The mistake I was making was that in Pro under Map Properties: Scene > Elevation Surface I was selecting Add New Surface rather than editing the Ground surface by selecting the Add elevation source button.
As for the big hole in the ground, I'm not sure. Different vertical datum maybe?
David