I wasn't what you'd call a bedwetter, but I have a few related memories anyway. The earliest of these is of lying in bed while Mom put me in my bedtime diaper--a cloth prefold, pins, and plastic pants. For an assortment of reasons, I believe I was three years old. That would be after potty training but before I was staying dry at night. From what Mom has shared, that went on for 4-6 months. I have no memories of waking up in either a wet bed or a wet diaper during that time, but one or both of those things must have happened with some regularity.
I have exactly one memory of waking up in a wet bed, and I believe I was seven or eight years old at the time. By that age, it was somewhat common for me to sneak diapers from my younger sister's room and sleep in them, but I hadn't done it on that particular night. When I realized my bed was completely soaked, I was so embarrassed and scared. I told Mom I'd gotten sick and thrown up in bed, but of course my room smelled strongly of pee, and she didn't believe me for an instant. To my relief, she didn't get angry at me either. She just sighed and began stripping the sheets off my bed.
Reflecting on this, I think what scared me the most was the loss of control, not the thought of Mom yelling at me. I didn't once think, "Wow, I wish I'd been wearing one of sis's diapers!" It was like babyness had been thrust on me rather than being a matter of choice, and I really didn't like it that way. In the years since, I've come to enjoy the thought of waking up in a wet diaper, but I'd still want some control over when and where.