I wouldn't put it past Cuomo to defy the legislature and refuse to resign. Even Northam never got to this point.
In Northam's case, both his potential successors had baggage revealed during the same time period (rape allegations against Fairfax, Herring's blackface scandal), and next in line would've been the Republican President pro tempore of the Senate (not completely sure, but didn't he also see a blackface controversy arising at that time?). This is not the case here, Hochul has been pretty much uncontroversial so far.
Hochul has been a nonentity as Lieutenant Governor. She's clean and she isn't personally threatening to anyone.
The conflict to look for with her is whether her political views have changed since her last period of political independence in Congress, when she was the sort of Democrat who campaigned on opposition to illegal immigration and gun laws.
She has tempered much of that over the past decade, but it's worth noting that we're facing the prospect of New York State being led by a woman from Erie County with a Joe Manchin-esque legislative voting record, even if that description remains nothing more than a curiosity that has little bearing on how she chooses to govern.
I imagine that if she got elevated to the governorship she'd take the Gillibrand route of moving to the left once in a statewide position since it's already been proven to be an effective strategy in New York.