From what I gathered (years ago, so take it with a grain of salt), he couldn’t get funding because he hugely miscalculated the distance to India if you’d travel west, like more than half the the distance. Most sailors and scolars knew better, but somehow he got the funding from the Spanish queen.