Can I get a counseling for not responding to a text while asleep?

You should definitely rebut the counseling statement. Especially if the sender is on a different network than you, text message timely delivery is NOT guaranteed. I would seriously take this higher as this is lazy leadership. They should have called you.

CPL, you certainly have a bullet for rebut. Your NCO should have called you instead of just texting you. Another question is raised in my head as to why you weren't called until 20 minutes AFTER you were to report. Had you been one of my Soldiers, I would not have been lazy to just text you, and I CERTAINLY would not have waited that long to call you. Your NCO should have called you @ 0630 asking why you were not present. But, to answer your question, technically yes you can get one since you were "notified" (and I will use that term loosely) of when and where to report and you failed to do so, as this (kind of) falls under "Failure to follow the orders of a Non-commissioned Officer". That being said, ENSURE that you write your rebut in the comment block that you are allowed to write in. Personally, your NCO FAILED you and FAILED in their duties. In the Army, one must choose when to fight certain fights, and I would recommend you fight this one. If need be, take this further up the chain if you need to.

No, but it's amazing what leaders get away with these days. I've gotten a negative counseling statement for talking to a chaplain and one for not reporting to duty because I was sick in quarters (on narcotics) and was not legally allowed to drive. I only got the counseling statement because the person who said they'd cover my duty, didn't show up. Somehow that was my fault.

You have to determine whether it's worth the hassle to fight it. My character screams yes, but after a few weeks or months of stress you might think differently. Use your chain of command, if that fails try IG. My personal experiences have been unsuccessful, but remember a negative counseling doesn't follow you.