If you truly expect to realize your dreams, abandon the need for blanket approval. If conforming to everyone's expectations is the number one goal, you have sacrificed your uniqueness, and therefore your excellence.
When the Olympics and World Cups come around, that's when you see the real outpouring of support that there really is for female football.
I think the concept of seeking fame and fortune in women's football in the States is a bit idyllic.