No more no less than I was expecting from this instrument, very happy to have come across it on youtube !
Of course it takes a little while to really get the hang of it, but one short session is enough to start making bird-like sounds. You wouldn't buy a flute expecting to know how to play it right away, this is no different, takes practice to master.
Definitely not for children, and unless you live alone, not for the indoors. I drive to the mountains to practice as not to annoy my flatmates, but also because that's where the birds are (I don't reckon the seagulls at my window would be very receptive but who knows).
It's a frail instrument in nature so I'd recommend buying at least two, it's not like you'll be ruined.