The situation in Venezuela has been a slow moving disaster for a number of years now but I don't believe that Guaidó inspires much trust or confidence among many Venezuelans. He's already been seen as being co-opted by the Trump administration and to this day, Latin Americans and most of that entire region (including the Caribbean) continue to be wary and mistrustful of the U.S.
Obama inspired some trust in many Caribbean nations and parts of Latin America but he is only one man. The only other American president who inspired any type of trust is probably Jimmy Carter during his post presidential years.
I'm not even sure what a small portion of the military will do when the rest still cling to some type of loyalty to Maduro, who many in the military don't even care for but believe he is stronger than Guaidó and will likely cling to power, especially if Guaidó is Maduro's only opponent.