The best summary of Annie's reason for deciding to go over Niagara Falls in a barrel in "Queen of the Falls" is:
Annie must close her charm school and worries she will run out of money. A newspaper article about Niagara Falls inspires her to perform a stunt that could make her rich quickly.
This captures her financial motivation and the inspiration she found in the article.