Whoa there, slow down tiger. At least on the overnighter. You gotta walk before you can run.
And an overnighter isn't gonna be balls to the walls sex for 8 hours. Even if your dick could do it, I don't think a provider would want that. Yes you should have more sex than a short visit, but overnighters are more for the companionship.
Back to the point, learn to walk before you can run. Get some regular solo sessions under your belt first.
Mistakes happen. You're spot on with an apology and seeing if you can schedule with an extra cancellation fee added. She may have simply blocked your number thinking you're a time waster. If so, move on, it happens.