Mattie I'm going to give you a good talking to here, brace yourself!
I am officially the World's Lightest Sleeper. Fact. I CAN hear a pin drop. I wish I wasn't like this but there is no getting away from it, I can't help it. Much the same as my DH can't help snoring. But bottom line is... compared to some, his snoring is not that bad, but he does snore.
I spent years struggling through. My problem is... if I am woken, I don't just fall back to sleep. It takes me anything from 20 minutes to 2 hours! I was like you, sleep deprived, worried, going to bed was an ordeal blah blah.
For the last god knows how many years, my DH has slept in the spare room. It has revitalised our marriage! He isn't worried about snoring. I'm not on edge through restless nights and lack of sleep. I honestly think you will both find it a relief if you go down this route. Your problems will be sorted overnight.
I cannot tell you how much better I feel for getting sleep. Now... if I wake (which I do - I'm a poor sleeper) it's not down to anyone else, it's just me. I have a white noise machine, my sleep is still not good, but I'm not being woken 10 times a night by my DH. He is quite happy in his own bed, he hasn't got me hissing at him all night 'stop it stop it'. Everyone is happy.
Now... all the DCs are home for Christmas and we're going to have to share a bed for about a week
but I can cope if I know that it won't be long until I will get a good night's sleep. Holidays, ditto, but we usually drink lots of wine and that sorts it enough!
Stop fretting about it all. Your DH can't help snoring. You can't help being a light sleeper. Take action, sleep in different beds, you will wish you'd done it years ago. I did.