Beware that when you’re first exposed to a new thing: a car, a college tour, house, etc. you will feel AMAZING and totally seduced by the shiny newness. Be cool. Remember that glitters is not gold. Things don’t need to be perfect and even if the house is it doesn’t mean life will be.
Start a yearly “review” right before school year. Raise allowance as appropriate. If they want more money, they’ll have to take on more responsibilities.
Have them sort change, and eventually to count it. It teaches them to gather things that are alike, it's an introduction to money and it occupies them for 15 minutes! Just make sure they're old enough to be past the point of putting coins in their mouth.
Failed?
Lift yourself up, or live there.
You know the work you need to do, be it physical, mental, emotional or spiritual, etc. So do it. Do the work.
The only bitterness in failure comes from not having the guts to get back up again.
I once asked my mom if my grandmother (her mother in law) was rich. Her reply: “No, but she likes to think she is.” I think she meant my grandmother spent money like she had plenty of it when she really did not. Can relate. I hope you do better!