OK i get that non-football fans simply don't understand the attraction, and often don't understand how hard it is to get a season ticket for some teams. (disclaimer: i go to all my team's home games, but i go with my DH, and if i ever go without him i don't tend to get drunk and stay out all day)
The thing is, a normal season ticket, i think, only covers league matches, but it is possible that it is for cup matches too. But.
There are 20 (?) teams in the Premier League. That is 38 matches, of which means 19 home games. Out of 52 weeks, that's not even half. Also, it is one day out of the weekend (not counting midweek matches) so there is the other day. (does he get absolutely bladdered?)
So the first thing is: 19 whole days out for you, without kids, to do with as you please. You ought to be able to find something to do, for your own sake and mental health.
The playing football is a bit more problematic, but again, you need to make a trade-off here with him or persuade him that it is time to stop.
As for not leaving the kids with their parent? you have to let that go and make him parent. Because if you don't, you have bigger problems than a season ticket. You would be doing your DCs, your DH and yourself a huge favour if you make him see that he is a parent and he has to do it properly. You really can't have it both ways: you can't moan that he goes out but then moan that you can't leave them with him. (IME men like this often turn to outside help in situations like this, that is ok, it is shit but the DCs are generally fine with that)
Don't have another child. Why would you? you can't cope with the two you have - but don't let that get you down, they do get easier as they get older. Also, they might get more interesting for your husband and he may take an interest. Don't waste that opportunity by having another small one that you don't want him to look after.
There is a way. Have you ever been to a football match? my club has an absolutely brilliant family stand with face painting, cheap tickets for the children etc etc, it's a brilliant day out.