TLDR; eh, seems overkill and obtrusive. If you want to simulate bed wetting, just use a drip feed.
Hahaha. As an engineer, I am laughing my ass off. This is absurd but at the same time I can't help but like the idea.
Some notes. Using a pump is overkill. I recommend a elevated inverted bottle with surgical tubing going into a cheapo double action pneumatic solenoid. You can place a the bottle on a variable hotplate, also tends to be cheap. And there's plenty of ways to control outlet velocity of the fluid cheaply.
Mechanically, there is several considerations when purchasing a pump, which includes variable load and pump speed (potential energy calculations inlet + outlet elevation), large continuous power input (battery + powe), and NOISE NOISE NOISE. You'll probably wake yourself up with the pump noise. Using a elevated inverted bottle and pneumatic solenoid is kinda the way to go. Elevated IV bags esentialy do the same thing, but without the pump.
Heck, can probably just use an elevated bag with drip feed.
I entertained the notion, and now I going to advise against doing anything that I have said. Mostly safety issues.
Finding materials to play nicely with your skin over long periods of time is difficult, escpially in 'extreme conditions' of a soiled diaper. This is a problem that prosthetic/biomedical engineers have to deal with all the time.
This has high potential to reduce the quality of your sleep and induce toss/turning. Tubes themselves are problematic devices (kinking, wraping, irritation, ect).
Lastly, working with devices that do a work (pump) can have dangerous failures, even if they're small cheap units. E.g. Pump -> surgical tube kinks -> water backups -> pump overloads(most don't have safety features built in) -> pump smokes and/or catches on fire.
So yea, this sounds obtrusive and overkill.