The hope was reaching East Asia, not America.
They Catholic Monarchs didn't know about America. They were very skeptical of him being able to reach East Asia, and rejected the project several times.
They (under)funded the trip because:
-they had a surge of cash a few months after they toppled the last remaining Islamic area in the peninsula: Granada.
-they didn't want other kingdoms to open the route before they did.