Yes, I think batteries can effectively fail after a full discharge. No, I don't think the N900 will run with a dead battery even if it's plugged in.

I think the solution starts with a well-charged battery, which you should get when your desktop charger arrives, though it's possible you may also need to reflash depending on exactly what happened.

Good luck! I think you're on the road to recovery.