My DW and I were contestants on our last
DCL cruise. The previous posters are correct... it's not the question that can get a little risque... it's the answers.
We were asked the famous "What's the most unusual place that you and your wife have discovered the magic". My DM and DS were in the audience. Imagine the looks on their faces when I said, "On the balcony of a cruise ship." The audience erupted in laughter

and the CM that was acting as the host took several minutes to compose himself.

BTW... it was NOT on a Disney ship!
There were several other humorous questions along with equally humorous answers.
The good news is that my DW and I answered all the questions the same and we won.
As for the OP question... It depends on your DH's sense of humor. As with all audience participation events, if you enter it with the thought that you will go with the flow and enjoy yourself, it will be great. If not, it could be a LONG cruise.
As a side benefit, you will become minor celebrities after an appearance.

People who saw your performance WILL comment as they see you throughout the cruise. Even CD Rachel made a comment to me the day after our startling answer.
We had a blast, but I also know it's not for everyone.