Is it possible to get back into academic research after being dropped due to funding problems from 6 year postdoc?
I think that you need to decide whether what you really want is to be in research or to be in academia.

It sounds to me like you right now you are considering only positions at major research universities.  With respect to that, you are indeed in a very bad position: competition is fierce, funding is getting tighter, and if you don't already have a network of people interested in you at this stage in your career, you are likely to find it difficult to secure a position of this sort.

There is, however, a much larger universe of possibilities if you really want academia or you really want research.  


If you really want to stay in research, there are often a much larger number of positions in various flavors of government, non-profit, and industrial research, including many that are very similar to academia.  In some fields, the amount of cutting-edge research being done outside of academia is actually much larger than the amount being done inside of academia, if one was to count up the whole bizarre ecosystem of startups, foundations, consultancies, pilot projects, little-known sub-departments in large companies, etc.  Life is typically somewhat less stable in this world than with tenure, but likely no worse than you have known as a postdoc and in many cases much better.  By your user ID and 6-year postdoc (ouch!), I'm guessing you're in a biomedical field, and this is definitely the case for much of biomedical research.
If, on the other hand, you really want to stay in academia, there are a much larger number of positions at institutions whose mission is primarily educational. A key challenge there will be if you have not been doing any teaching at all as a postdoc, but you'll likely be quite competitive in terms of your intellectual credentials.


So yes, your dream of going directly from postdoc to tenure track is likely not going to happen, just based on the numbers and how you describe your current status.  If you step into the demi-monde world at the borders of academia, however, you can likely find a path to continue your research and, if it is fruitful, may even find yourself coming back into traditional academia through a side door.