If your finances are low enough, a full need or very close to it school could potentially give a “full ride” or similar.
I know many athletes in D1, D2 and NAIA schools getting a “full ride” or pretty close. Other than D1 basketball and FBS D1 football, it is of the “do it yourself” variety, and usually the coach helps put it together. I am very familiar with a program that uses this extensively. They have several kids that go to school very cheaply but don’t actually get that much of their money from the athletic department. They heavily recruit kids who qualify for automatic scholarships (merit, first generation, etc) hard. Several parents of those kids say they are at or near full ride, but I know they are only getting a few thousand of athletic scholarship money. The coaches help them find the rest from other places, using money available to anyone if you know how and where to apply.