Emotional support buddies are great!
Sounds to me like the dude is not interested in you except as such. Considering how close you make your relationship sound, however, I'm a little surprised he isn't more straightforward. Whether or not you'll be able to retain the friendship as is depends on the nature of your future relationships. I think onesnowyowl outlined this quite well.