Hi @AussieRecharger,
Thanks for your interest and questions. 
The chronic sleep disorders are different at different times. I believe they are exacerbated by anti-depressants, but I sink too much into major depression if I stop taking the medication. Sleep disorders affect so many aspects of life.
For example, I have had long periods of time when I was up all night every night and sleeping from dawn to dusk. This makes even the daily basics difficult, eg. going to shops or appointments that need to be done during daytime hours, other things.
In a way it's lucky I like the night for the peace and quiet. I feel most clarity of mind and relaxed then on the whole. As you suggested, I make the most of being awake all night when that is happening and I am unable to shift out of it. I have had a lot of enjoyment and some recognition of my unpaid creative work. This helps with confidence as well and gives meaning to my life.
With the NDIS, a major goal is to get to the point where I go out of my home every day for exercise, group activities, other things to get me more connected to the world outside my home, where I spend too much time by far and have for much of my life. This will improve both my mental and physical chronic illnesses.
I will have a support worker very soon. She has helped me a lot before some years ago and I believe I will improve in wellness with her again.
About your son's asthma, that condition can happen to anyone. It seems to me unlikely you did anything wrong. I think some health problems are just bad luck. Sorry your son and you are going through this. I feel for you both. 