No, I don't think it's weird. Quite the contrary. 8th house people do tend to think about death more than the average person, and are not fearful or squeamish about it. Consequently they are suited for jobs dealing with death. This might also include ICU hospital staff, hospice workers, paramedics, charitable organizations trying to find cures for currently incurable diseases. I merely acknowledge that those other people who don't have an 8th house emphasis don't get where you're coming from, because their focus is elsewhere.
As a senior citizen, my parents were both gone by the time I was 35. My brother died from cancer. Probably a dozen or so friends and neighbours have died in the past 8 years. With one of our friends and neighbours who died of cancer in the local hospital's hospice room, we visited him several times per week, and we saw how he deteriorated.
Yes, it's hard to watch sometimes, but I think it's harder to die alone, or for the spouse to face death without a support network.
I've been to just a couple of funerals with an open casket. While I wouldn't want this for myself, for some loved ones, it does bring a sense of closure, to see the body at rest.
Also, not all the work at a funeral home involves dealing with the body. It's a bit like a reception center, with some employees scheduling the viewing or open house arrangements, sometimes programs to be printed if a memorial service will be held there, arranging for a casket or cremation, possibly making arrangements with a church, and so on.
The near bereaved family members are often in no emotional condition to do this, so it is a service to them to have a professional to handle the arrangements.
The last time I was more closely involved with a funeral was my brother's death. The funeral home staff couldn't have been more helpful, respectful, and supportive.
Your moon is in the 8th house of service. In Aquarius, it does give you a sense of emotional detachment, which should be helpful for this type of work. But also, I cannot imagine that people in this profession wouldn't have special methods of clearing their minds so that it doesn't run them 24/7.