Video him when he comes home next, show him the state of his parking, throwing up etc.
Buy a breathalyzer ftom halfords, show him how much he is still over the following morning.
If you report, police will wait outside the pub and pull him over once he has pulled off. They will arrest him and keep him until he blows alcohol free - this could be hours. He will have to attend court which carries a minimum mandatory of a 1 yr ban, he might be offered the drink aware course which may reduce length of ban by a quarter. He will be fined, dependent on his income but upto 125% of his earnings plus court costs. He will have a criminal record which can impact on his job, future jobs, even going on holiday to some countries. The crimimal record will stay there for 11 years until its spent. If he is caught again within so many years then its a minimum mandatory 3 yrs ban for 2nd offence.
This will have a massive impact on your life - family finances, being the only driver, insurance costs afterwards, shame of being married to drink driver, if he finds out it was you who reported him etc. If you chose to report him then you need to know what you could be doing to your family and the impact it will have on you as well.
Its hard to balance the argument of report and save a life but this could be at the expense of yours. Personally, for whats its worth, i would video, show him and threaten to post to his family and friends if it happened again. If it did, then send the video and if it continues then report.