While they had expected popular support, the exact opposite happened with the Cuban population and the armed forces rallying around Fidel Castro. It took just 3 days for Castro’s forces to defeat the US-sponsored invasion and the result was humiliation for the United States and JFK.
https://en.wikipedia.org/wiki/Bay_of_Pigs_Invasion
https://en.wikipedia.org/wiki/Assassination_of_John_F._Kennedy