Sorry for your loss.
I can see both sides of this. Personally I hate funerals, as do many. I've been to so, so many over the years. I do attend funerals of those I was close to, sometimes dh comes with me sometimes he doesn't, depending on childcare, travel, time off work etc. Sometimes it's easier for me to just go. He still supports me, even if he's not physically going.
Dhs family on the other hand believe that everyone goes to the funeral, it doesn't matter if you've never met the person, you go. I've been to many funerals where I've never met the person, dragged 5 kids and a wheelchair, I've travelled 4 hours to funerals of people I've never met, but because dh is related to them in some way, we all have to go. They see it as support, respect etc, there we are sitting up front mourning a person we never met, while friends of the deceased are standing at the back, which personally I find 2 faced. I feel I'm taking the seat of someone who will have known this person well.
I also hate the wake after, obviously over the years I now know most people. However when I was dating dh I found myself sitting at wakes on my own, I was so shy and knew hardly anyone, everyone was chatting and catching up, but God it dragged and I felt so awkward.
Obviously if you need him with you, you should say that you need him there. I know lots of people who just don't go to funerals because they really can't make themselves go.